Report date setup wrong

asd22 · ‎08-27-2025

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:

any tips to get a better format on it?

Dr Atul G- LNG · ‎08-27-2025

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

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

Dr Atul G- LNG · ‎08-27-2025

it has been hidden in the drop down.

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

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

asd22 · ‎08-27-2025

manged to make it as you said, but its still this weird format:

Dr Atul G- LNG · ‎08-27-2025

Because you are using two different fields in Group By and Trend, it is showing like this — which is the expected behavior @asd22

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

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

asd22 · ‎08-27-2025

but when i only have the "last login" it still show up like this with the weird format

Dr Atul G- LNG · ‎08-27-2025

Hi @asd22

The behavior is expected. The reason is that we are getting year-on-year data for 12 months, and the system is trying to stack everything into one bar. If you change the interval to per day or per month, it will display correctly.

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

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