nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculating an average of a table column and using it in a new calculated column of the same table

zjeriet

Hello,
 
I have a table with measurements in one column. Now I want to normalize these measurements. Means calculating the average of these measurements and then create a new column which contains a measurement minus the calculated average.
 
My approach was using a page variable.
I managed to create a new column in the table which takes the measurement value and subtracts the page variable.
But I'm having trouble assigning the page variable the average value of the measurement column.
 
Any ideas on this one?
 
Thanks
 
Gerrit

Find more posts tagged with

Comments

pricher

Hi Gerrit,
 
Unless I am missing something in your question, you don't need a page variable here. All you need to do is create an AVERAGE aggregation on measurements at the table level, and then create a new data item that subtract the AVERAGE aggregation from measurement. Example attached.
 
Regards,
 
P.

zjeriet

Hi pricher,
 
Thanks for your solution.
That's indeed an easy one.
 
I also found a way but it's really the long way home.
I've created a page variable, calculated the average on the onFetch event of the data set and then used it in the calculation of the new column.
 
Again thanks for your help