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**