Count, Set Analysis

[flyhigh15]

1. Calculate the count of customers who purchased a product in the specified year.
2. year = 2015,2016,2017

[abhijitnalekar]

Hi @flyhigh15 ,

Use below.

count({<year={'2015','2016','2017'}>}distinct customer)

[flyhigh15]

not working .....  year can any from given orderdate.

[abhijitnalekar]

@flyhigh15 ,

do you have year filed in the data model then you can use that field or try belo

count({<year(Orderdate)={'2015','2016','2017'}>}distinct customer)

[flyhigh15]

i have tried this.. is this write???    =

count({<year= GetFieldSelections>}distinct CustomerID)...

[abhijitnalekar]

@flyhigh15 

if you want to change your expression value on the selection you can use below

Count(distinct Customer)