Forum Discussion
Handling Multiple dates inside visual
Anonymous
To do what you want you have to have role-playing date/time dimensions. You can't achieve it with just one Date table. Sorry. Please create as many date tables as there are dates you want to visualize independently.
Anonymous
To do what you want you have to have role-playing date/time dimensions. You can't achieve it with just one Date table. Sorry. Please create as many date tables as there are dates you want to visualize independently.
Makes sense...so I should create another date table (as I only want a visual with 2 of the dates), but then what? Should I create inactive relations between all dates again? Should I relate the date tables as well?
I was actually thinking about something more on the line of using Summarize to group the costs by maintenance end date, but I don't know if that would work.
Inactive relationships are created when one and the same table joins to another on 2 or more different fields. You don't have such a situation since in this case each date table will join to the same table on one (and different) field.
Thanks man, I did a little digging on role-playing dimensions and I understood what was missing. It's actually quite simple: since I had relationships with all dates, I was just a matter of using the maintenance end date as legend.