-
1. Re: Adding a column of averages and sorting shapes
Jason RochinNov 6, 2017 9:06 AM (in response to Mattias Elm)
Hi Mattias,
I can calculate the average per row but could not get a sort to work.
To calculate the average per row use this calculation:
WINDOW_SUM(SUM([Rating])/
TOTAL(COUNT([Rating])))
This cannot be used as a sort as it uses Table Calculations.
This is displayed as a discrete value in the table.
See attached for my attempt.
Thanks,
Jason R.
-
STOM_rating.twbx 53.3 KB
-
-
2. Re: Adding a column of averages and sorting shapes
Mattias Elm Nov 6, 2017 2:22 PM (in response to Jason Rochin)Thanks Jason! Thats a start!
Instead of Nulls I now got #Missing in the table. Can't seem to find that in your code. Any ideas where that came from? An effect of the table calculation. Not that it's a problem, just curious!
Now what remains is figuring out two things:
1, How to sort the table on the average rating column, within the boundary (pane?) of the geographical variable.
2, Another option that I also need; how to sort on the column for the latest data (sep 2017) from most stars to fewest (again within the boundary of the geographical pane).
Figuring out how to sort shapes isn't easy.
Thanks,
Mattias E.
-
3. Re: Adding a column of averages and sorting shapes
Jason RochinNov 7, 2017 6:36 AM (in response to Mattias Elm)
1 of 1 people found this helpfulHi Mattias,
I got rid of the nulls by making the calculation with LOD instead of Table Calcs.
Still not able to sort though. I think this is because of the way the measure is show as discrete.
'Average Calculation'
(SUM([Rating])) / SUM({ FIXED [Leveransområde],[Leverantör (group) 1]:COUNT([Rating])})
'LOD Average of Total/Count' - This one goes on rows as discrete
AVG({ FIXED [Leveransområde],[Leverantör (group) 1]:([Total Sum Ratings]/[Count Number or Ratings])})
Thanks,
Jason R.