Cumulations and data selections

michael089 — Fri, 15 Jun 2018 14:27:38 GMT

Hello,

I have the following issue which I cannot seem to solve. I have the following table:

MyTable:

LOAD * INLINE [

Date, Host, Recent, OS

2018-04-01, HostA, True, Win

2018-04-02, HostB, True, Win

2018-04-03, HostC, True, Win

2018-04-04, HostD, True, Win

2018-05-05, HostE, True, Win

2018-05-06, HostF, True, Win

2018-05-07, HostG, True, Win

2018-05-08, HostH, True, Win

2018-05-09, HostI, True, Win

2018-06-10, HostJ, True, Win

2018-06-11, HostK, True, Win

2018-06-12, HostL, True, Win

2018-06-13, HostM, True, Win

2018-06-14, HostN, True, Win

2018-05-10, HostO, True, Win

];

I want to present this data aggregated by date and counting (cumulating) the deployments like this:

For the "Deployments" column I'm using the following expression: RangeSum(Above(Count(distinct Host),0,RowNo(TOTAL)))

This works fine until I do selections on month - e.g. just displaying May and June 2018:

Due to the selection, the deployments of April are not counted. However I want the correct number of deployments being displayed independently of the selection of month.

Can anyone point me to the solution for this problem?

topic Cumulations and data selections in App Development

Cumulations and data selections