Report date setup wrong

[asd22]

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?

[asd22]

Hello i have another question, why is this report not showing correct last 3 months? 

[Dr Atul G- LNG]

Hi @asd22 

Looks like a data issue, because it should either show records or no record updates in the last 3 months based on these conditions. Remove the condition Active = false and then try again.

[asd22]

was the same without the condition sadly

[Dr Atul G- LNG]

Then check the data, mate, because the report will only pull from the records

[Bhuvan]

@asd22 

When you group by 'created', or any 'date time' fields, ServiceNow reporting engine pre-defined bucket list or breakdowns will be displayed in the report. It is not a configurable option.

You can use different filter conditions like last year or last 6 months and see if it displays as per your requirement.

You also have out of box indicator configured for active users and you can display it in a dashboard and can use time aggregation to view the user count easily for various timelines.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan