Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
Possibly a noob question but I got this dashboard with a sheet with a table on it, showing names and percentages (response rates). The value of these rates are calculated with the following in the expression editor:
count(distinct Satisfact_review_id)/sum({<year={$(vCurYear)}>} [No. Patients])
The outcome sometimes exceeds 100% and I want those values to be shown as 100%+, otherwise of course the calculated percentage itself.
In just language it should be:
IF <result above mentioned expression> greater than 100%
show 100%+
ELSE show <result above mentioned expression>
I tried diverse IF constructions, looked for some other options like pick for example but I could not get it working.
Are conditional expressions possible in this specific case and if yes, how can I put it together the right way?
Thanks in advance for thinking along and reaction and kind regards,
Aad Dijksman
The Netherlands
I would try:
if(
count(distinct Satisfact_review_id)/sum({<year={$(vCurYear)}>} [No. Patients]) > 100, // or 1?
'100%+',
count(distinct Satisfact_review_id)/sum({<year={$(vCurYear)}>} [No. Patients]))
Lockematthewp,
Thanks for the reply. Got the change to think along with an experienced guy and we did the trick this morning using the rangemin() chartfunction. Works like a charm. I will try yours too by the way.
Kind regards,
Aad Dijksman
The Netherlands