I’m trying to use the table calculation “avgOver” to calculate the average across all vendors for a particular metric in a table.
For reference, these are the columns of the table.
Vendor, per unit spend.
I basically want to create a new column that calculates the average “per unit spend” across all the vendors. Which means that for this column, all the rows would have the same value for this column.
I tried using “avgOver” with PRE AGG, but it didn’t work. This is how I did it:
it shows different values for each row.
Any help would be much appreciated, thank you!