Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a quarters filter such that, my accounting numbers and quarters are related
Accounting Period | Quarters |
1 | Q1 |
2 | |
3 | |
4 | Q2 |
5 | |
6 | |
7 | Q3 |
8 | |
9 | |
10 | Q4 |
11 | |
12 |
I have a single selection in quarters filter,
if I select Q2 I am getting
Accounting Period-4,5,6 in KPI
Required Output should be -1,2,3,4,5,6 in KPI i.e. it should generate a series starting from 1
I can't see any accounting periods in your KPI - there are however month names there.... so I guess that is what you are thinking about then?
If so - you could change the $ into a 1 in your set expression modifier.
I can't see any accounting periods in your KPI - there are however month names there.... so I guess that is what you are thinking about then?
If so - you could change the $ into a 1 in your set expression modifier.
Thanks Petter,
Can you please elaborate why we take 1 instead of $?
These are both set expression identifiers. So $ means the current selections whereas 1 means all data ignoring any selections.
You can find more info and explanations here: