Forum Discussion
Syndicate_Admin
Administrator
AdministratorMeasure for average column per product
Good day I have this table as an example where 3 columns branch, toy lot and quantity where I need to get the average of the quantity column based on the columan toy lot that is:
| branch | Toy Lot | quantity |
| 15047 | 148 | 1 |
| 15047 | 148 | 2 |
| 15047 | 148 | 5 |
| 15047 | 148 | 8 |
| 15047 | 895 | 6 |
| 15047 | 895 | 7 |
| 15047 | 895 | 15 |
| 15047 | 36 | 9 |
| 15047 | 36 | 78 |
| 15047 | 36 | 89 |
| 15047 | 789 | 10 |
| 15047 | 789 | 90 |
| 15047 | 789 | 78 |
| 14369 | 107 | 15 |
| 14369 | 107 | 25 |
| 14369 | 56 | 78 |
| 14369 | 56 | 9 |
| 14369 | 56 | 3 |
| 14369 | 56 | 89 |
And I want to take the measure to show:
| branch | Toy Lot | Average amount |
| 15047 | 148 | 4 |
| 15047 | 895 | 9.3 |
| 15047 | 36 | 58.6 |
| 14369 | 789 | 59.3 |
| 14369 | 107 | 20 |
| 14369 | 56 | 44.75 |
Is it possible to carry out this measure ? The data is updated from a database.
Load your data into a table visual. Change the Lotquantity column to "Average" aggregation. (That is called an implicit measure)
1 Reply
- lbendlin
Super User
Load your data into a table visual. Change the Lotquantity column to "Average" aggregation. (That is called an implicit measure)