Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Ci number discrepancies in monthly reporting.

Passion_of_SNOW
Tera Contributor

I am generating a report to show how gradually we have added more and more CIs in PROD through Discovery. However, the numbers are not making sense to me. See below -

 

Passion_of_SNOW_2-1759806018820.png

I am using the filter below - 

Passion_of_SNOW_0-1759805995182.png

 

My question is why the CI numbers have changed? Why the same report that I ran on Sept is showing different number of CIs created for each month than the report I am running today in Oct? 

 

 

 

1 ACCEPTED SOLUTION

Bhuvan
Giga Patron

@Passion_of_SNOW 

 

Can you go to the data source table and group by created date to confirm the count ?

 

When using date/time fields for aggregation, try using trend option for reporting. If it does not work, share more details on the reporting configuration.

 

Below is for reference

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0758167

 

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

 

Thanks,

Bhuvan

View solution in original post

1 REPLY 1

Bhuvan
Giga Patron

@Passion_of_SNOW 

 

Can you go to the data source table and group by created date to confirm the count ?

 

When using date/time fields for aggregation, try using trend option for reporting. If it does not work, share more details on the reporting configuration.

 

Below is for reference

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0758167

 

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

 

Thanks,

Bhuvan