Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to filter a pie chart using an expression to count the Product IDs where ("Program" = "Math" or "Liberal Arts") and Graduation Date >= 10/1/2022.
I tried these expressions and none of them work. Any help welcome!
Attempt 1
=count({<Program={'Math'}>+<Program={'Liberal Arts'}>+<[Graduation Date]={">=$(=DATE(44835,'MM/DD/YYYY'))"}>}distinct [Product ID])
Attempt 2
=count({<Program={'Math'},Program={'Liberal Arts'},[Graduation Date]={">=$(=DATE(44835,'MM/DD/YYYY'))"}>}distinct [Product ID])
Attempt 3
if(Program='Math' and Program='Liberal Arts' and [Graduation Date]='{">=$(=DATE(44835,'MM/DD/YYYY'))"}',count(distinct [Product ID]),count(distinct[Product ID]))
Attempt 4
if((Program='Math' or Program='Liberal Arts') and [Graduation Date]='{">=$(=DATE(44835,'MM/DD/YYYY'))"}',count(distinct [Product ID]),count(distinct[Product ID]))
As below
=count({<
Program={'Math','Liberal Arts'}
, [Graduation Date]={">=$(=Date(Date#('10/1/2022','MM/DD/YYYY')))"}
>}distinct [Product ID])
As below
=count({<
Program={'Math','Liberal Arts'}
, [Graduation Date]={">=$(=Date(Date#('10/1/2022','MM/DD/YYYY')))"}
>}distinct [Product ID])