Forum Discussion
Helper IIIProbably an easy count Q
Hi Shpongle ,
It was showing as Day no, because the earlier selection in the x Axis was Day (under the heirarchy of Date).
Have changed the x axis values .Pulled the Date from the Calendar table and removed the hierarchy.
Incase you want for each date, you can change it the values of X axis to Categorical.
Hope this helps.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Helper IIIHi Harsh,
I appreciate the effort here - The only problem is that the chart is showing the total number of tickets as opened and closed for each day! The other weird thing is that it's not showing the date along the bottom, just a day number.
Hi Shpongle ,
It was showing as Day no, because the earlier selection in the x Axis was Day (under the heirarchy of Date).
Have changed the x axis values .Pulled the Date from the Calendar table and removed the hierarchy.
Incase you want for each date, you can change it the values of X axis to Categorical.
Hope this helps.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
- Shpongle
AT LONG LAST!!! It's working! I feel like a goof for not being able to figure it out and I'm still going to need a minute to review why it's working but.... IT WORKS!
I'm not sure why my date table didn't work but yours did. I think my date table might need a little review. Once I switched it over to your calendar, *boom*.
I spent an embarrasing amount of time on this, and so I am very grateful to you, Anonymous, for taking the time to help!
Kind Regards,
Mitch