Forum Discussion
Plotting Open/Closed in same table/graph...
Hi,
So, I appreciate the reply. I'm not entirely sure why this worked, but to solve this I needed to change my "Created" column (the timestamp of when the case was opened) and "Closed" column from datetime to date. I'm not sure why this worked. Maybe because the time never lined up with the time in the Calendar table and reducing the timestamp to just a date allowed it to find a match. Not sure. Regardless, exhausting....haha
Thanks for the reply. That just give me a single number like the command I previously listed for "ClosedCount". But, rather than the closed count, it gives me the open count (because it's counting the blanks).
The expected output is like below (taken from another post here):
But what I'm getting are just a single, total number (I used your suggestion for the "ClosedCount" column:
Do you want the following results shown in the table? Did you try the Matrix by expending the data?
Hi,
So, I appreciate the reply. I'm not entirely sure why this worked, but to solve this I needed to change my "Created" column (the timestamp of when the case was opened) and "Closed" column from datetime to date. I'm not sure why this worked. Maybe because the time never lined up with the time in the Calendar table and reducing the timestamp to just a date allowed it to find a match. Not sure. Regardless, exhausting....haha