I’m trying to calculate AVERAGE and expecting to see 8 ( (11+5) /2 ), but I’m seeing 8.33
How? What do I need to do to get 8?
Hi Eleri! It appears you are taking AVG for total usage days and then taking an Avg of that AVG for a total which may be causing the issue. You may take a look at using the AvgOver function - avgOver - Amazon QuickSight