"Last Selected Month" Values in a Column without using procedure

Mira Slaouti
Mira Slaouti Active Partner
Fourth Anniversary Level 300: Expanding Board in Your Organization Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board
edited July 2020 in Platform
Hi everyone,
I would like to create a Layout with a column that contains the data from the last month selected in the screen without using the procedure with step "apply selection to layout block"
I tried to use the "Last Value" Option but in case that the data are null for the last selected month , I had the last non Zero value
Thanks in advance for your help 

Mira

Answers

  • Brendan Broughton
    Brendan Broughton Active Partner
    Third Anniversary 100 Comments 100 Up Votes 25 Likes
    edited July 2020
    Hi @Mira SLAOUTI depending on the data and the months you're selecting you might be able use an approach like the below to get what you need (without having to use a procedure to dataflow.

    I actually have calendar year 2020 selected, but the cube I want to show only has data to July 20. I only want to show data for the latest month (with data), ie. July, but with the full year selected.

    The top dataview is the raw data, the bottom is with 'last value' applied.  The third/small/right hand dataview is using a few things to only show the last month.  The bottom snip shows the layout setup in the third dataview, all blocks other than the last are hidden.

    In this instance blocks A/B/F are the same, just with 'total by' set on A and B, and 'offset = 1' set on block B.  Depending on how your screen selections are working and the data in the cube you want to display you may need to set A and B up differently.  But the same approach should work.  You'll just need to be mindful of screen refresh rates.



    image


    image
    Let me know if that helps or if you want any more information.




    ------------------------------
    Brendan
    bbroughton@bi5.com.au
    Australia
    ------------------------------
    -------------------------------------------
  • Mira Slaouti
    Mira Slaouti Active Partner
    Fourth Anniversary Level 300: Expanding Board in Your Organization Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board
    edited July 2020

    Hi @Brendan Broughton ,  

    Thanks for your reply.

     What I would like is the data of the last selected month.( not the last filled month)

     I put you some screenshots to explain my problem.

    In the first screen I have all my data , without any time selection. In the second screen , my data with month selection ( from January to July , this selection is dynamic and each user can modify it ) , and in the 3rd screenshot what I would like to have in a different colmn without using Block references : the data of the last selected month . 
    Thanks in advance for your help 
     image


    image

    image




    ------------------------------
    Mira SLAOUTI
    Consultante
    FASTCUBE
    France
    ------------------------------
    -------------------------------------------

Categories