How to plot a Combination Chart with Data composing of 2 dates (e.g. Created, Closed) on the same Axis?

Greetings Spotfire Community and Gurus:

I have the following data set which I am trying to plot on a combination chart with stacked bar charts for the count of tickets Created (positive) and Closed (negative) along with the lines showing Cumulative Created and Net Created (Created - Closed) on the same Axis.

I am having trouble composing the correct SUM OVER expression to plot the cumulative or net created line. Any tips or assistance is greatly appreciated. Thank you in advance.

 

Please find below and attached the Excel and Spotfire.DXP of the data set I am working with.

EXAMPLE OF RAW DATA (Structure)

IDX SITE STATUS CREATED CLOSED
CVO4125 EH OPEN 1/1/2018  
CVO4127 VT CLOSED 2/1/2018 2/20/2018
CVO4128 LA OPEN 2/16/2018  
CVO4129 VT CLOSED 4/1/2018 5/1/2018

EXCEL CHART EXAMPLE OF GOAL

Knowing that with the information provided in that format I have to UNPIVOT the data correct? Hence, here is an example of the UNPIVOT RAW DATA

IDX SITE STATUS ATTRIBUTE VALUE
CVO4125 EH OPEN CREATED 1/1/2018
CVO4127 VT CLOSED CREATED 2/1/2018
CVO4127 VT CLOSED CLOSED 2/20/2018
CVO4128 LA OPEN CREATED 2/16/2018
CVO4129 VT CLOSED CREATED 4/1/2018
CVO4129 VT CLOSED CLOSED 5/1/2018

 

EXAMPLE OF CURRENT EFFORTS

 

(3) Answers

Login