Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Please help me on this function:
I have a table as shown:
Date group plan_checked visit_checked
Mon. 1 0 0
Mon. 1 0 0
Mon. 2 1 1
Tue. 3 0 0
Tue. 4 0 0
Wed. 5 1 1
I want to count the number of distinct Date&Group with plan_checked=0 and visit_checked=0. The result should be like:
Mon. 1
Tue. 2
Wed. 0
My function is:
SUM(IF(Aggr(SUM(ItemChecked)+SUM(MSChecked)+SUM(TPChecked),[Date]&Customer)=0,1,0))
It doesn't work.
Thanks for help!
How about,
=Count({<plan_checked={'0'},visit_checked={'0'}>} DISTINCT group)
How about,
=Count({<plan_checked={'0'},visit_checked={'0'}>} DISTINCT group)
Use Date as dimension and Count({<plan_checked={0},visit_checked={0}>} DISTINCT group) as expression