Recent searches
No recent searches
How to build a Fiscal Year Bar Graph in Explore
Answered
Posted Jun 02, 2023
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.
0
4
4 comments
Kristine Hancock
Ahmed Zaid You saved me. Thank you so much.
0
Rich Shupe
Can you share the resolution for the rest of the community? I can't find anything via search. Thanks!
0
Kristine Hancock
Rich Shupe 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 …
0
Ahmed Zaid
Hi Rich Shupe ,
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.
0