최근 검색
최근 검색 없음
How to build a Fiscal Year Bar Graph in Explore
답변함
2023년 6월 02일에 게시됨
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개
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