I'm attempting to add a line to a bar chart. The data for the line is a single point of data created with a custom formula. It's simply an average line that I want to show up over the bar data.
Here's my report and the point of data I'm trying to get in the line:
Here's the chart configuration screen from my dashboard component:
After selecting what I have, the chart legend says it's showing the line, but the blue line doesn't actually display. Now I've gone ahead and created a metric component to show that value, but I'd much rather have the line on the chart itself.
Any suggestions or guidance is most appreciated.
4 answers
Hi David, Use the PARENTGROUPVAL function, it will be something like
PARENTGROUPVAL(Activity.ActPo1__c:SUM, GRAND_SUMMARY)/8
