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
Views
Replies
Total Likes
If I understand correctly, you want to enter some goals as custom numbers in a report. So something like the following but you want daily instead of monthly:
Rather than using the day dimension in the calculated metric, you can use the position of the day in a day ordered list to associate the custom goal to the day or month or week. (Actually, I just posted something about making a Goals Report.) Here is what that that would look like for month, which has 12 segments. For daily, you would have 365 segments for the year, but otherwise the principal is the same:
So far, you have used the Cumulative function to number each month in the trended series. You used the Equal function to ask if the month number is 1 (metric_y). If so (the If logic function) set the value_if_true, which is the monthly goal. If not it sets no value. In other words, if the value is Jan (month 1) then set the value to your goal (value_if_true).
For a monthly report, you would use the month dimension in your left report column. For a daily report you would use the day dimension. Your calendar date for the report would be set to the date range you are after.
Do you need a different target for each day? Or would your daily target be as simple as "X" per day?
If you really need it to be different per Day, did you try "Day of Month" instead of "Day"?
Views
Replies
Total Likes
That makes sense! Thanks Jennifer
I can confirm that this works, thanks again. Only thing that I cant get to work is the sum on the top of the column. On the attached folder it should say 100+200+300=600. Instead of its saying 100. Is there a way around this? I need the sum in order to create a Week to Date target comparison as well.
Any Ideas are welcome!
Views
Replies
Total Likes
I don't think you can get a total with this type of calculation... Unfortunately in the entire month, there is a "Day of Week = 1" that exists, therefore it will match the first IF statement in the metric....
In your example, you have 100+200+300=600
Is this like a cumulative increase?
or are these just example numbers?
Basically I am trying to figure out if your Daily Goal is 100 so that each day your "cumulative" goal is the total from subsequent days?
100 per Day:
Or is it really that you expect to hit different goals each day?
Views
Replies
Total Likes
Hi Jennifer, thanks for your help!
Its a different pax target each day and it looks like this:
Day 1: 500
Day 2: 450
Day 3: 470
etc
Ideally I wan to create the following comparison:
Daily achieved pax vs Daily Target
Week to Date Pax vs Week to date Target
To do this I was looking for a way to sum the week days target.
e.g
Daily pax Daily target
1000 500
Week to date pax Week to date Target pax
1500 500+450+470=1420
Ok, let me think about this...
Of course, there is always Report Builder... where you have a little more control, but let me try a few things to see if I can get both a defined daily target, and a proper total
Views
Replies
Total Likes