GRC KRI with RAG color and a threshold rating based line chart

ujjwalababa
Tera Contributor

Hi all,

We store our GRC KRI metric results in [sn_grc_metric_metric_data] table and want to recreate the two reports in the attached screenshots using Platform Analytics, without moving to Excel or Power BI.

  1. Scorecard: metrics grouped by category, with red/amber/green threshold ranges, colored values per quarter, and a bar with a marker showing where the current value sits.
  2. Line chart: daily values with data labels and fixed green and red threshold lines.

I think the line chart works with a time series, and the scorecard can be done with a pivot or list plus conditional formatting. But I’m not sure about these:

  • Can the threshold ranges be shown as columns, pulled from the metric definition?
  • How do I group by quarter and show “n/a” for missing quarters?
  • Is the R/A/G bar with a marker possible natively, or only with a custom UI Builder component?
  • Can the threshold lines on the chart come from the metric’s configured thresholds instead of being hard-coded?

Has anyone built something like this? Any tips or examples would be great.

Thank you!

0 REPLIES 0