Reports

[mathewirene]

Hi All,

I have a requirement where the user has already provided me with a report built on the Catalog Task SLA (sc_task_sla) table.

The existing report is a Time Series Column chart.

It shows the daily Closed SCTASK count for the current month (X-axis = Date, Y-axis = Catalog Task SLA count).

Now the user wants me to enhance this report so that it not only shows the daily Closed SCTASKs but also includes the daily Open SCTASK count in the same graph for comparison (Open vs Closed per day).

I checked the configuration of the existing report:

Table → sc_task_sla

Group by → Stage

Trend by → Closed

Calendar → Standard calendar, per Day

My doubt is:

Since the report is on sc_task_sla, how can I also include the Open SCTASKs daily count?

Should I create another dataset using the sc_task table (filter State != Closed) and combine it with the existing report?

Or is there a way to achieve this within the same sc_task_sla table report using Group by / Trend by options?

Has anyone implemented a similar Open vs Closed SCTASK daily comparison in a single graph? If yes, what would be the best approach?

[Dr Atul G- LNG]

Hi @mathewirene 

In the old or legacy reporting module, there was an option called Multi-dataset, but I'm not sure if this is still available in the new Data Visualization tools. Please explore this further to confirm. Once you have clarity, you can proceed accordingly.

https://www.servicenow.com/docs/bundle/zurich-now-intelligence/page/use/reporting/concept/c_Multiple...

[Dhana3]

Hi @mathewirene ,

I think it is best to use data set option, as you can;t trend by 2 different fields.