Forum

This content is now out of date.

Visit Our Community

Display average value as Average line in charts

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.


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,

Dustin

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.