Question
How to report on CTA's opened vs CTA's closed
I need a single bar graph with 2 side-by-side measures, grouped by CSM.
The 2 measures are Count of CTA's opened, and Count of CTA's closed, within a time period.
I can figure out no way to do this other than creating a whole other "snapshot" table, with fields for "Total Opened" and "Total Closed". This would need triggers to keep it maintained in real-time. Those triggers alone would be a ton of work to implement, and I want to avoid that if possible.
Another option was to create a granular table with a separate record for each CTA Open and CTA closed event. This would be slightly easier to set up, but then I could only build the graph as a stacked bar graph, not a grouped side-by-side bar graph.
I can't be the first person to ever conceive of this report, and I figured there would have been some way to do it.
The 2 measures are Count of CTA's opened, and Count of CTA's closed, within a time period.
I can figure out no way to do this other than creating a whole other "snapshot" table, with fields for "Total Opened" and "Total Closed". This would need triggers to keep it maintained in real-time. Those triggers alone would be a ton of work to implement, and I want to avoid that if possible.
Another option was to create a granular table with a separate record for each CTA Open and CTA closed event. This would be slightly easier to set up, but then I could only build the graph as a stacked bar graph, not a grouped side-by-side bar graph.
I can't be the first person to ever conceive of this report, and I figured there would have been some way to do it.