I have a quick question on the data:
The 'Data' measure value is greater than 1 in many cases, example:- For area code 4143, Business Type Id - 6, Day - Monday, the data value is 7, 8 , 9 etc. Could you help me in understanding this measure? What does it signify?
Thanks for your prompt response. I double checked and the max and min value of
the ‘Data’ column is 1. I am not sure if I’ve missed something.
Only the ‘Time’ column has values from 1 to 24.
Those numbers are sums of values in data column for the Area_ID = 4143, BusinessType_ID = 6 Day = Monday.
In other words (eg. for the first row of your screenshot), there are 7 businesses open at 0000-0100 on Monday
in Area_ID 4143 and they all are in BusinessType_ID 6.
Hope this explains.
Please follow the steps, to calculate the averages by any dimension
Create the chart the way you do, then for "Data", change the aggregation to average.
If you require averages by multiple dimensions then add all those dimension to the rows and change the aggregation to average (refer to the above image) .
Since you maximum and minimum are 1, you will get result of average as 1.
PS - To learn more about aggregation, please refer to the below mentioned link
Thanks and Regards,