6 Replies Latest reply on Jun 6, 2018 7:05 AM by Jhon Smith

    Calculate Action from a single column

    Jhon Smith

      Hello,

       

      - I have column Action which contains Created and Resolved Values.

      - I have shown bar chart by week

      - Now I want line graph that how much still CREATED is left each week.

      For example

           Week1 = Created 10 and Resolved 6 so on line line it should be 4

           Week2 = Again Created 10 and Resolved 6 now for week2 on line graph the Created tickets(i mean total on Week2) should be 8

           and so on

       

      Please find attached book

      Please guide me.

       

      Thanks