Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report date setup wrong

asd22
Tera Contributor

Hello, when i try to get a report that shows active users for the past month, i cant get it to be as i want.

 

The report when i do anything with dates always ends up like this: 

asd22_0-1756282776642.png

any tips to get a better format on it?

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @asd22 

 

You are creating the trend report, so it is showing data by week. Also, apply a condition such as Created → Last Month

 

DrAtulGLNG_0-1756283012469.png

DrAtulGLNG_1-1756283053288.png

 

 

*************************************************************************************************************
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

18 REPLIES 18

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @asd22 

 

You are creating the trend report, so it is showing data by week. Also, apply a condition such as Created → Last Month

 

DrAtulGLNG_0-1756283012469.png

DrAtulGLNG_1-1756283053288.png

 

 

*************************************************************************************************************
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]

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

i dont have these options in my SN it seems

asd22_0-1756283566438.png

 

Hi @asd22 

 

use this Trend type:

DrAtulGLNG_0-1756284789435.png

DrAtulGLNG_1-1756284837230.png

 

*************************************************************************************************************
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]

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

i made a trend, but here i dont have calendar either 

asd22_1-1756283663962.png