Selection on screen

andreaLin....
andreaLin.... Active Partner
Board Developer Name Dropper First Comment
in Platform

Hi everyone,

I need to display data for different months on my screen. Specifically, I want the current month to be selected in the screen selection, and I also need a graph that shows data for the 12 months prior to the current month.

Can anyone guide me on how to achieve this?

Tagged:

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    Answer ✓

    Hi @andreaLin.... ,

    you can achieve that with a custom time dimension (e.g. "Month Selector" with member "Last 12" for example) as parent of the Month entity.

    That would be used to override the screen selection in the layout of the graph, using the "To" option.

    image.png

    The members can be set manually, but it's best practice to extract and reload the time tree to set the relations properly—there you'll have to apply some sophisticated ETL to derive the "Last 12" values to be set.

    Best,
    Helmut

Categories