Hello,
I am running a Tickets Solved by Month query using the date range Jul - Jun but the results keep populating in a calendar year format, despite the specified date range commencing Jul 1.
Similarly, when I try the Ticket Solved by Quarter feature, it interprets Q1 as January, not July.
How can I instruct the query to display the bar graph with July as the first month of the year rather than January?
Thank you for any insights.
Can you share the resolution for the rest of the community? I can't find anything via search. Thanks!
@rich24 I'm sorry but Ahmed's solution has been deleted for some reason. Let me play around with some Explore queries this week to try and arrive at it myself again. It was a year and a half ago and I cannot recall what Ahmed offered me off the top of my head. I'll be back …
Hi @rich24 ,
Sorry there was an incident few months ago that led to all my contributions being deleted by mistake. The solution for this one is to always add the year before the month in the attributes section. It should look like this
Let me know if that works.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.