Compare same month but different year - values don't make sense

[Diogo Cardoso1]

Hi all,

I did a report with opened demands’ date by month (example 1), but I also needed do compare the same information with the same months, but on different years. I tried to create a Time Series PA but it shows totally different results (example 2). In the first example values seem ok (lower than 100), but on the second example values seem way off, reaching almost 9k. I'm using "By month sum" because there is no "By month count" which would make more sense, nonetheless I'm almost sure that I'm using the the right indicators and filters.

Do you have any idea for this difference? Am I doing something wrong?

Example 1:

Example 2:

Data for Example 2:

I would be grateful for any help you are able to provide.

Diogo 🙂

[sachin_namjoshi]

In reports, you can use multiple sources to show data from previous years as well.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/co...

Regards,

Sachin

[Diogo Cardoso1]

Hi Sachin,

But am I able to make a report like example 2 using multiple sources ? I tried that and it didn't get the results I wanted to, it displays data as in example 1.

Thanks