This content is now out of date.

Visit Our Community

Display average value as Average line in charts


We have one Yellowfin report in which we are calculating the average for particular column using the formula Totals-> f(x) Calculated Total and now we want to display that value (Shown in the screenshot below) as an average line in our Bar charts.

Forum image

And also we want display that value as a separate column in our Report as shown below:

Forum image

Kindly let us known how to achieve the same.

Thanks and regards,
Prateek Arora
Hi Prateek,

Thanks for sending in the question and apologies for the delay in responding! Unfortunately, you cannot pass column sub totals to a new column. You would have to either use an advanced function or calculated field to accomplish what you are after.

Here is an example using the statistical advanced function 'Mean':

1. Drag in your Availability Percentage field onto your report a second time

Forum image

2. Apply the statistical advanced function mean to the duplicate column

Forum image

Forum image

3. You could then hide the field from the report and use it as normal in your chart

Forum image

Forum image

Would this option work for you? Please let us know if not and we can look for other alternatives.

I look forward to hearing back, and apologies again for the delayed response!

Kind Regards,