7 Replies Latest reply: Dec 9, 2016 2:10 AM by Lukas Roček

# Log of counts day by day

 I have table with 3 important atributes: CT[string], DATE[yyyy-mm-dd] and OpenClosed[OPEN,CLOSED]. I have combo chart (on X axis is Date {2016-6-12} day by day) with two values: `Count( {< OpenClosed = {'CLOSED'} >}Distinct CT)`and `Count( {< OpenClosed = {'OPEN'} >}Distinct CT)` for open and closed CTs. I need add line chart to this combo chart with count of Open CTs day by day. For example: 4th December 2200 CTs, 5th December 2310 CTs, 6th December 2250 CTs.....KPI TOTAL OPEN CT is value for last day (last reload) solved by Count( {< OpenClosed = {'OPEN'} >}Distinct CT). It is count of ALL open items in table. So I need view this value for each day in combo chart as line...  Is it possible, or I must do some special table in Excel in this case? Thanks for your answers
• ###### Re: Log of counts day by day

Hi

Not sure to well understand your requierment, but if you want to know day by day your stock of Open CT

try this for line chart

rangesum(

above(

Count( {< OpenClosed = {'OPEN'} >}Distinct CT)

)

)

my mistake the right formula is

rangesum(

above(Count( {< OpenClosed = {'OPEN'} >}Distinct CT),0,Rowno())

)

• ###### Re: Log of counts day by day

I need sum of count for each day...count for first day is 30, for second 20, but i would like to see 50 (30+20) for second day...etc...

• ###### Re: Log of counts day by day

rangesum(

above(Count( {< OpenClosed = {'OPEN'} >}Distinct CT),0,Rowno())

)

• ###### Re: Log of counts day by day

It is better, but I have sorting by date descending, so I need reverse it...

• ###### Re: Log of counts day by day

try with below :

rangesum(

below(Count( {< OpenClosed = {'OPEN'} >}Distinct CT),0,Rowno())

)

• ###### Re: Log of counts day by day

Neither ABOVE, neither BELOW, but BELOW has better numbers, I think. BUT: On start of chart it looks good, to middle of chart. Then line falls down to zero... It looks like some Gauss line...