GRC KRI with RAG color and a threshold rating based line chart
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12m ago
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.
- 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.
- 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