set analysis Possible combination counts

[shruthibk]

Hi All,

I have sample data as below 

ID,Location,market,submitdate

01,CA,America,'2018-10-01',
01,TX,America,'2018-10-01',
02,CA,America,'2018-10-01'
01,PA,America,'2018-09-01',
02,TX,America,'2018-09-01',
01,TX,America,'2018-09-01'
01,CA,America,'2018-08-01'

expected output

submitdate,count of product id

2018-10-01,        5

2018-09-01,         4

2018-08-01,         1

Logic is for  check the possible  (ID &Location) with previous months

I am able to achieve this in text object but I am not getting how to achieve in the chart with dimension as date .

Thanks,

Shruthi B K

[shruthibk]

ya it will be 5 for 01-10-2018, 4 for 01-09-2018 and 1 for 01-08-2018

[sunny_talwar · Accepted solution]

Try this

Sum(Aggr(RangeSum(Above(Count(DISTINCT Key), 0, RowNo())), Key, (submissiondate, (NUMERIC))))