We currently have a csv that we need to report on. How do i create a calculated measure that will give me the average. here is how the data looks in the file:
Hi,
For creating the report you describe you must have one more column of “1”. This column is the record counter; we need to have such a measure for implementing the counts by specific values of the BU and Env columns.
The data mapping could be the following:
After the data import you can use the “Env” dimension for showing averages and counts and create the average calculation with the custom formula:
Your report could look like this:
Kindly,
Janis, eazyBI support
Thanks this helps