Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My fields are Year, Visits, Mbr_Id, Provider
So, I need to show how many members by Provider had 2 or more visits. I don't even know where to start.
If visits >= 2 ,count(distinct(Mbr_Id)) but I am not sure how to determine if a mbr had more than one visit. Is there anyone that can help?
Well, maybe this will help you:
Aggr (Count ({<Visits={">=2"}>}Distinct Mbr_Id),Provider)
Cheers
Hi,
let say user selected as Year 2018 then
Dimension:
Provider
Measure:
count (distinct {$<Year={"$(=Max(Year))"},Visits={">=2"}>} Mbr_Id)
if still has issue, can you your mock data and expected output. tks
Thanks
Deva
//if(count(Visit)>'2',Count(Mbr_Id),'NA')
Count(distinct {<Visit = {">=2"}>}Mbr_Id)
May be this
Count(DISTINCT {<Mbr_Id = {"=Count(DISTINCT Visit) >= 2"}>} Mbr_Id)
This is working, but is it possible to replace the =Max(Year) with a variable $(vPriorYr) and the Visits with another variable $(Visits)