Hello. My group sales manager has a dash to track running sales totals, with year over year by calendar year, so Jan to Dec. What he really wants is to track it May-April. Since our FY runs Sep-Aug, there's no built in way I can see for this. And I'm at a loss to figure how to get at it in a custom range. What am I missing?
We're trying to get a line graph where x-axis is order date by week of "year", with week1 starting May (so about calendar week 18), and work with a year offset so we can get YOY.
Thanks for any suggestions.
Sharon
HI Sharon,
It's expected that you could accomplish this filtering on ORDER DATE May 2022 - April 2023 and using the PREV() function, but unfortunately I found some defects, which will show up on the defect list tomorrow:
When I use it with Months on the axis, and PREV([Months in Date],12), it works fine, but when I switch the axis to Weeks and PREV([Weeks in Date],52), it breaks.
The other defect is when trying to produce an RSUM() curve of a give value that uses PREV(), the results are just wrong.
I've confirmed both issues in v15 and v16 and have reported both issues to Sisense for resolution.
Given that, the only way I can see to accomplish your goal is with an order-level Analytics customization that groups orders by weeks from May 1.
Chris, Thank you for looking and reporting the issue. I will see if tracking months will help my group sales mgr,
Thanx,
sharon