create a report to display the number of catalog item created(sc_req_item) for each month .

[chandan2212]

Hi All, 

Can you guide me to create a report to display the number of catalog item created(sc_req_item) for each month  in the coloumn and rows , in the row list of each catalog item should display and coloum only total should come

[AndersBGS]

Hi @chandan2212 

And where do you phase issues? What have you tried so far?

[chandan2212]

Hi @AndersBGS  ,

I am receiving this report, and I have applied a filter for the last three months. I want to see January, February, and March individually.

[AndersBGS]

Hi @chandan2212 

@but you have created a list virew? Instead you can apply a time series visualization and then pr. Month… this will give you a count pr month where you afterwards can click into the data.

[Tanushree Maiti]

To shows catalog item counts by month in a matrix format, you should use the Trend or Pivot Table report type.

Refer: Month Wise Catalog Item Counts Submitted (Table View) 

           https://www.youtube.com/watch?v=edQWYnGoWC8

           Measuring Catalog Item Usage Comprehensively Across All Produced Tasks in Performance Analytics

Helpful links :

Reporting on Catalog item variables

Reporting on Requested Item Table