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?
