Conditional showing value when percentage exceeds 100%

[dijksman]

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

[lockematthewp]

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]))

[dijksman]

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