Forum Discussion
Cumulative count in Table
Hi All, I need to find the count of tickets by every row by date that how tickets are closed till the date in every row. Please check the below sample output i need Tickets till Current Clos...
Greg_DecklerI need a totals by each row with closed date how many they are this one doesn't help me
I'm not getting the logic for the calculation. Why do you have multiple rows of 4/4/2018 closed date with different numbers for the calculation you want?
Greg_Deckler If Suppose
Ticket No 1 its closed date is 4/6/2018 Open date is 4/6/2018 then it is count as '1'
Ticket No 2 its closed date is 4/4/2018 Open date is 3/28/2018 then it is count as '1'
Ticket No 3 its closed date is 4/14/2018 Open date is 3/27/2018 then it is count as '3' because till the opendate of 4/14/2018 there are total alltogether 3 tickets closed