Forum Discussion
Multiple Line Chart from Table with 2 Dates
I'm trying to create a Line Chart with 2 lines based on the same table. My table is a list of help desk tickets with unique key being the ticket ID #. Each Ticket has a Created Date and a Resolved D...
Deku
Super User
Super UserYou would need a role playing date dimension.
So the date dimension will have a realtionship to each date, one active and one inactive. Your one measure would be the count using the active relationship. The second would need to activate the inactive relationship with calculate( , USERELATIONSHIP() ).
Then can plot the date from the date dimension on the x axis and the measures on the y axis