Adding Calculated Field to Table

[Stars]

Is it possible to add a calculated field to a table of some sort?

I have raw data for three different companies.  I would like to make a dashboard for one company that would display the data for that company and then the average data from all companies.  Please see yellow portion of attached example.  I'm unsure how to add the average column to a table.

[Kashyap_R]

Hi 

Try this expression in the average column

= Avg( All<Metric> Value)

Thanks

[naumanshah]

Better to create a measure for average instead of having it computed at table level. Since, if we pre-calculate and store average for a metric and company, then dynamically computing average for all companies may not yield correct results as average of average is not always mathematically correct. So, you may simply add a measure having calculation =AVG(Value)

[jyothish8807]

Hi ,

Create a new table in backend:

Load

Metric,

Avg(Value) as Average

resident <your table>

group by

Metric;

Then use "sum(Avg)" in your expression in chart

Br,

KC