Forum

Display average value as Average line in charts

1 December, 2015

Hi,

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.

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

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