Forum Discussion

jdogcisco's avatar
jdogcisco
Resolver I
8 years ago
Solved

Plotting Open/Closed in same table/graph...

Hello,   I am importing a single csv ("issues") of case/ticket date. Each row is a case and its details including, but not limited to... Ticket #, Opened, Closed 1, 1/2/18, 1/5/18 2, 1/3/18, 3,...
  • jdogcisco's avatar
    jdogcisco
    8 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Do you want the following results shown in the table? Did you try the Matrix by expending the data?

 

 

 

 

 

jdogcisco's avatar
jdogcisco
Resolver I
8 years ago

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