Charting Data in a Dashboard

Lee Ratzlaff

Hello,

I am working on developing a dashboard for clinicians to share a client's assessment scores, and I want to include the threshold for if the scores are clinically relevant (the dotted lines in the image below). These would be constant, regardless of the individual client's scores.

Is there a way to structure a chart in a report in this way?

Paul Newcome

You would need to include that data in the grid that the chart is referencing. For example, you would have [High Threshold], [Low Threshold] and [Actual Score] columns in your sheet. This would allow you to show three different lines on the same chart.

Paul Newcome

You would need to include that data in the grid that the chart is referencing. For example, you would have [High Threshold], [Low Threshold] and [Actual Score] columns in your sheet. This would allow you to show three different lines on the same chart.

Lee Ratzlaff

Thanks, Paul! I was able to add those thresholds into my sheet and create a chart that includes the cutoffs as well as the individual client scores. But, it doesn't look like there's many formatting options for these charts. It would be great to be able to make the lines dashed or otherwise different, and select the high limit for the chart without having it a separate line. But, this is a huge improvement from what we had been working with!

Paul Newcome

Happy to help. 👍️

Feel free to Submit a Product Enhancement Request for the dashed lines and any other improvements to the chart formats that you can think of.

In the meantime, I usually use the fill feature for the lines that are "actuals" and no fill for my target or threshold lines.

Lee Ratzlaff

Oh, that's AWESOME!!! Thanks!

Paul Newcome

Sure thing! 👍️