Get selected month from Time Slider

[rphss]

Hi all

we are using standard stories - no application designer.

We are using one time slider on calmonth and tried to get the slected count of month from that slider

for measure calculation. So we found the aggregation part in measures but this option only provides the

the aggregation on the posted values . For example : the slider is set to January 2021 to December 2021, means 12 month selections.

A customer has postings only in month from March to December . So all aggegations provide a count of 10 only. But we would like to use the count of 12 month of the slider in our formulars.

Any option to get that?

Ralf

[N1kh1l]

rphss

I assume you will always want to have Total month count as 12 for your calculation irrespective whether there are values or not.

You can try something like below.

Create a Aggregation measure of type COUNT DIMENSION and set the dimension as Date. in my e.g. Month Count.

Create another Measure of type Restriction and restrict the previously created measure (Month Count) by Date and pass All to it. This will return you 12

Now you can use this Total Months in your further calculation.

Output:

Regards

Nikhil

[rphss]

Hi Nikhil

actually we want to take over the month from the time slider input control.

Sometimes we are selecting 3 minth , 12 month or 24 month.

I was hoping there is a function [inputcontrol1].selectedMonth which can be used in the table.

Ralf

[N1kh1l]

rphss

It works with the filter. If I select more than 12 months it calculates accordingly.

Nikhil

[rphss]

Hi Nikhil

I have tried but I dont see the constant selection optoin. how do I get there?

[N1kh1l]

rphss

Is your model based on live connection ? I think Constant selection is not available for live connection 😞

Nikhil

[rphss]

oh no , again live connection issue. 😞

Anyway thanks

[N1kh1l]

rphss

I can feel it 🙂