Dear community,
I hope this you’re all well.
This is the metric I want to fill my dimension property with:
My quest is: I want it to give me the last client type filled before January 23
Can you please help me with this?
Solved
Fill date informed before a date
- Wallflower
Best answer by Keiran
Hi Khadija,
I’ve tried to put an example together;
I created a Dimension for Client
And created a Metric of Client Type, structured by Month x Client (Using Dimension: Type)
Then I wrote the following formula;
'Client Type' [FILTER: Month.Year = Year."FY 22"] [Remove LASTNONBLANK : Month]
This finds the last nonblank in the year FY22, and so excludes the Jan23 value.
I hope this helps with what you’re trying to achieve!
+11- Employee
- Answer
Hi Khadija,
I’ve tried to put an example together;
I created a Dimension for Client
And created a Metric of Client Type, structured by Month x Client (Using Dimension: Type)
Then I wrote the following formula;
'Client Type' [FILTER: Month.Year = Year."FY 22"] [Remove LASTNONBLANK : Month]
This finds the last nonblank in the year FY22, and so excludes the Jan23 value.
I hope this helps with what you’re trying to achieve!
Keiran | Pigment Specialist (Head of Support, EMEA)
- Wallflower
Hello
Your answer actually solved the first part of my problem, and so I was wondering if there was a way to filter from FY 22 to current date out?
Thank you,
+11- Employee
Hi
Do you currently store the ‘current’ month as a variable or Metric somewhere? Or would you need to do this also?
Thanks!
Keiran | Pigment Specialist (Head of Support, EMEA)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.