Selection on screen

andreaLin.... · 2025-03-03T11:27:29+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Selection

Accepted answers

Helmut Heimann

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.

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

All comments

Helmut Heimann

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.

Best,
Helmut