Forum Discussion

cdizzle22's avatar
cdizzle22
Frequent Visitor
4 years ago
Solved

Using Dates in Visuals

Good Afternoon,

 

I am currently trying to build a dashboard that measures a count of tickets opened and closed by Year, Month, and Day in a stacked bar chart or line chart. 

The counts of opened and closed tickets is coming out correctly but when I try to use Date as the x axis I cannot get the date to respect each value. 

 

If the date of opened is used, the number of opened reports correctly but the number of closed is not accurate. If the date of closed is used, the number of closed reports correctly but the number of opened is not accurate.

 

When creating a new table for date and creating a relationship this does not come out clean either.

 

How can I use a default date heiarchy that reports both closed and opened for a given, Year, Month, or Day correctly.

 

Thanks!