create a report of operational ‘service offering’ cis and ‘business process’

[Kunal1601]

I need to Create a report of operational ‘service offering’ cis and ‘business process’ Cis where display in menu is true and also need to Add these  columns in it :-

• No. of INC logged in last 6 months
• No. of PRB logged in last 6 months
• No. of CHG logged in last 6 months
• No. of REQ logged in last 6 months

How should I add these column into my report as these attributes are not present into 'service offering' table and 'business process' table .  For example - If CI name is ‘active directory password unlock’. I need to know how many inc/change/ req logged   In last 6 months. for this I want to create a report.

[Mark Manders]

You will not be able to report this per your requirement, since the number of created tasks is not a field. 
You could create a report on the task table, created on the last 6 months, where task type is one of these tasks and group by task (add ci/process to your condition).

Depending on the exact requirement (somebody wants to see something), I would just create a dashboard(tab) for this. Create single scores reports on number of INC/PRB/CHG/REQ and add interactive filters on 'created' (default: last 6 months, add others, so it can be changed, if necessary), and filters on Service Offering and Business Processes so they can be selected as well. That way it is easy to have that overview (and it's a clickable number to go to the task overview).

You could also add a bar graph on task type, so you will have one overview per selected Service Offering(s).