Report date setup wrong

asd22 · 4 weeks ago

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 · 4 weeks ago

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 · 4 weeks ago

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 · 4 weeks ago

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

Dr Atul G- LNG · 4 weeks ago

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 · 4 weeks ago

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

Dr Atul G- LNG · 4 weeks ago

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]

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