Report comparing data of current and previous month

lorenzoS1 · ‎10-19-2022

Hi all,

we are trying to create a report in which data of the current month is compared with that of the previous month.

We tried to replicate the solution proposed in this post https://www.servicenow.com/community/platform-analytics-forum/is-it-possible-to-create-a-report-with...

without success.

The report seems to "sum" the values for each month without showing the values for the single days:

Widget:

Indicator:

Indicator source:

we also tried to modify the parameters of indicator and indicator source, but the result didn't change.

Could you please show us what we are doing wrong?

Thanks in advance for your support!

Lorenzo

Sebas Di Loreto · ‎10-28-2022

If you want to use the "previous period chart" feature do the following on the widget:

- put the checkmark on "previous period chart"

- that should have added the "previous period settings" section, select months and 2 on number of periods.

- ensure the Time series field is empty, that should show the days of the current month on the dashboard.

Doing this will compare the current month with the previous month (not the same month an year ago) on a DAILY display on the horizontal axis.

Alternatively, you can go back to your widget and configure it this way:

- Time series: by month...

- "previous period settings" section, select years and 2 on number of periods.

Doing this will compare the current year displayed by month on the horizontal axis with the previous' year months.

Hope this helps.

If I helped you with your case, please click the Thumb Icon and mark as Correct.

View solution in original post

Stefano Gorla · ‎10-26-2022

Hi Lorenzo,

I have the same problem.

were you able to solve the problem?

Regards,

Stefano

Sebas Di Loreto · ‎10-28-2022

I am trying to understand your issue.

Are you having trouble with the "previous period chart" feature or is something else?

If I helped you with your case, please click the Thumb Icon and mark as Correct.

Sebas Di Loreto · ‎10-28-2022

If you want to use the "previous period chart" feature do the following on the widget:

- put the checkmark on "previous period chart"

- that should have added the "previous period settings" section, select months and 2 on number of periods.

- ensure the Time series field is empty, that should show the days of the current month on the dashboard.

Doing this will compare the current month with the previous month (not the same month an year ago) on a DAILY display on the horizontal axis.

Alternatively, you can go back to your widget and configure it this way:

- Time series: by month...

- "previous period settings" section, select years and 2 on number of periods.

Doing this will compare the current year displayed by month on the horizontal axis with the previous' year months.

Hope this helps.

If I helped you with your case, please click the Thumb Icon and mark as Correct.

Flamingo_David · ‎02-08-2023

I would also love to be able to compare previous month to the month previous to view historical trends. Can this be achieved. So that at the 1st of each month i can compare the previous month to the previous month before.