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?