Forum Discussion
Bando
10 years agoFrequent Visitor
KPI line query
Quick query. I'd like to add a KPI line on the y2 axis (%SLA) at 95%. Is there a simple way to do this or is it a case of creating another column of data with the KPI in against the values...
WillT
10 years agoCommunity Admin
You can also use a reference line for this. Go to the formatting pane (look for the paintbrush icon under the viz icons) and there's a card there for it. HTH!
- Bando10 years agoFrequent Visitor
I'm revisiting this again and there is no reference line option for this type of combo chart. I've also tried using calculated columns in my data but because I'm agragating the data by months with different numbers of rows in each monthe it also calculates the % for the targets too.