Rendering just a "letter grade" on a KPI

Q&A
,
1

Hi there, we’re trying to a render a status chart where a particular value will yield a grade e.g. if the value is 100 it would be an A. Our calculated field is as follows:

ifelse(
    LatestCoverageAverage >= 0.75, 'A',
    LatestCoverageAverage < 0.75, 'B',
    LatestCoverageAverage < 0.50, 'C',
    LatestCoverageAverage < 0.25, 'D',
    'N/A'
)

We want to show the letters on the dashboard but adding this measure on the KPI renders it as a Number/count instead. Any advice please?

2

Hello @MrAbd , welcome to the Quick Sight community!

The KPI visual won’t be the best option for this. I would recommend using an insight narrative and creating a custom narrative to handle the conditional logic.