How to get report by month side by side for 2 years?

priyaaprab
Giga Contributor

Hi,

I want to get "Month" report side by side for 2 years. For ex, attached the picture. I tried creating Report with different types (bar chart, columns chart etc), but nothing is showing as similar to my requirement (to have side by side months for 2 years). I could only make Reports with charts straightforward ( all months come one after another and then month from next year starts. I don't want this way, i want like comparison month for years side by side). Could you please help/share me the step by step to achieve this?

 

sidebyside.png

2 ACCEPTED SOLUTIONS

Thanks @AndersBGS  for confirming my doubt. SO @priyaaprab  in short get PA and your issue will be doen.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

Hi @priyaaprab ,

 

How much knowledge do you have in relation to PA? Based on that you know how to create PA jobs, Indicator sources and automated indicators, then it's quit simple. 

 

  1. Ensure that you have data collected on the automated indicator back to January 2022. 
  2. Create a widget with check mark in "previous period chart"
  3. In the previous period settings, set "range of periods" to "years"
  4. In the previous period settings, set "number of periods" to "2"

Above will give the following result:

 

AndersBGS_0-1704442573465.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

16 REPLIES 16

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @priyaaprab 

 

I tried with Trend report but not getting this. May be by PA it can be done.

 

Let me add expert @AndersBGS 

 

What your thoughts mate. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AndersBGS
Tera Patron
Tera Patron

Hi @Dr Atul G- LNG ,

 

Thanks for looping me in 🙂@priyaaprab, this is not possible through standard reporting / the report designer, you instead need to utilize performance analytics where you have the "previous period" available. Please see example below:

AndersBGS_0-1704380226887.png

 

AndersBGS_1-1704380396704.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Thanks @AndersBGS  for confirming my doubt. SO @priyaaprab  in short get PA and your issue will be doen.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi Atul, Can you please guide me with step by step to do through PA to achieve this with some sample. Because, that's not what i don't know exactly how and where to set up this and access PA.