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

Ahmed Zaid You saved me. Thank you so much. 

0


Can you share the resolution for the rest of the community? I can't find anything via search. Thanks!

0


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


image avatar

Ahmed Zaid

Zendesk LuminaryUser Group LeaderCommunity Moderator

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


Please sign in to leave a comment.

Didn't find what you're looking for?

New post