Good Day All!
I want to add a reference line to a bar graph using a calculated field but when I drag & drop a reference line on the chart, the calculated field I want to use doesn't show up in the Value drop-down. Instead there is another calculated field that I am using as the values in the bar chart
The field I want to use is named 'Metric 1 Avg' and has the formula WINDOW_SUM(SUM([Visits w/ Tobacco Screening]))/WINDOW_SUM(SUM([Visits w/ Vitals]))*100
The field that shows up in the Value drop-down is named 'Metric 1 Calc' and has the formula [Visits w/ Tobacco Screening]/[Visits w/ Vitals]*100
The reason I can't use the Metric 1 Calc is that the reference line uses the average of that field, calculating the average of averages for all sites in the bar chart and what I want is more like a weighted average based on the number of visits at each site.
Thanks in Adavance for any help!
Brian
Put the calc you want to use on the Detail Shelf. Then your axis will see it as an available option to use as a reference line.
