Forum Discussion
Daily Rate Over Time Calculation and Visual
Hi,
One of the main issues I noticed in your file was that the data types are not set properly. When you`ll do that, all the date columns will show hierarchy for day, quarter, month and year.
The reason behind this is the calendar table that you`ve created. Rather than having a separate table for the calendar, you can use calculated columns for the calculation you need to do. You`ll get monthly data using the assignment start date as well by using the date hierarchy instead of the date.
Please mark it as a solution if this works for you!!
Regards,
SM
Hi SM,
thanks for your suggestion, unfortunately, this is not fixing the issue that I'm having.
The Column data types are set correctly.
I need a dedicated Calendar Table as the real report is using a lot of different Fact Tables that have a Date column.
Scenario described above is only using one facts table as an example.
I believe that my issue is that the calculation is only using one active relationship and giving me Daily rate information only at the start of the assignment but I need this information for the whole duration of the assigment.
BR,
Kris
Hi, Anonymous
Your needs are not clear, do you only need to set Arne, what about others?
Like:
Also, can you talk about the logic and usage scenarios(use in what visual) of the Daily Rate over time (Months) of the while unit?
If you can show the desired result in visual and calculate logic, we can help you soon.
By the way, it's not easy to show rows that don't exist in the data, and connect two tables with relationships.
Janey
