Question
How to create a calculate metric that shows daily-specific targets
- January 4, 2024
- 2 replies
- 1765 views
Dear all,
I would really appreciate, if you could help me, which function I can use to create a calculate metric that shows daily-specific targets to be able to make a comparison of measured daily passengers versus static daily-specific target numbers.
I have tried a nested if function as per the attachment below. I was thinking to use "Day" instead of "Month of Year" and create 31 segments for all days of the month. I could then use this to create the if statement. Only thing I would need to do is to update the static numbers each month with the new targets. Unfortunately I can only create spesific segments ie Day= 1/1/2023 and not Day contains 1/.
Any ideas?
Best regards Iraklis