Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
is there a way to convert a calculated measure to a dimension?
I have an if statement formula that I would need to use in a set analysis but I am not able to do that
If I could convert it into a dimension then I would be able to use it in a set analysis
Here is my if statment
=if (sum(sumPatientSatisfactionSurvey )>0,1, sum(sumPatientSatisfactionSurvey )) +
if (sum( sumMeasuringTNA) > 0,1 ,sumMeasuringTNA ) +
if (sum(sumMeasuringScreening) > 0,1 ,sumMeasuringScreening ) +
if (sum(sumQIProject1Project) > 0,1 ,sumQIProject1Project)
What i would want to find out is
Count ({<(if (sum(sumPatientSatisfactionSurvey )>0,1, sum(sumPatientSatisfactionSurvey )) +
if (sum( sumMeasuringTNA) > 0,1 ,sumMeasuringTNA ) +
if (sum(sumMeasuringScreening) > 0,1 ,sumMeasuringScreening ) +
if (sum(sumQIProject1Project) > 0,1 ,sumQIProject1Project)) ={"1"}>} physicianID)
But I can't do that
Any suggestions?
Not sure I understand your issue..Do you wish to convert a calculated dimension to a measure?
did you try using a simple measure like
Count(physicianID)?
pl podt a sample app
May be something like the below
Count({<physicianID={"=sum(sumPatientSatisfactionSurvey )>0 or sum( sumMeasuringTNA) > 0 or sum(sumMeasuringScreening) > 0 or sum(sumQIProject1Project) > 0 "} physicianID)