Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want an expression in a chart that only flags Location_ID_Key if the location has two products, HEM and PSL. Below does not work. count({} DISTINCT Location_Id_Key)
Hi
Please apply below formula with your field name in Expression and check if the location id is coming where location has 2 products.
IF(AGGR(COUNT(Location),Product)<2,0,AGGR(COUNT(Location),Product))
I guess it will help you.
Regards,
~Vinod
hi
Trylike this
count({<product={'PSL'}>*<product={'HEM'}>} DISTINCT Location_Id_Key) //this count the location id key where product contain both psl and hem..
hope it helps