Question
Decypher
US
Last activity: 8 Sep 2022 11:02 EDT
Set rolling 13 months on line chart
Good Morning,
I have a working chart that shows 12 months of data using this Calculation builder (pega v.8.1.8):
The month number of .pxCreateDateTime
The month number of [Date Value]
with a filter on the report definition of .pxCreateDateTime is equal to Current Year
The customer wants to show a rolling 13 months on this chart so they can compare Jan to Jan and Feb to Feb this year with previous year.
My question is how can I get to 13 months rolling on this chart. I am a novice so the more details in any answer the better. Please let me know if any other information is needed.
Capgemini
GB
You can do this by creating a report definition that groups results by month and year numbers, then filtering the date by previous 13 months.
Decypher
US
I got this to work on another chart but what I am finding now is that my Case Status variable which I believe is like your total sales, has 5 status I need to show. The included image shows 3 but there will be 5 case status(s). I am currently not getting the above to work with this variable which makes sense. I am not sure if this is a situation I need to count the years and filter by 13 maybe. Thanks for the help so far.
