Hello everyone,
As you can see on the example table I have a column named USER, a column named Quantity and a column named Location.
I was first trying to calculate the average number of items(=Quantity) that a USER would pick from a location so I used this expression:
Sum({$} Quantity) / Count ({$}DISTINCT Location) and then i would choose a user out of a listbox.
My issue is that I want to calculate the minimum of items that a user would pick from one location and aggregate those minimum per day.
My ultimate goal is to have a chart with the days on x-axis and a line showing the minimum that was picked per day (for the whole users at first and then the minimum for one USER if I select one from a listbox)
Example Table Based om my data:
| USER | QUANTITY | LOCATION |
|---|
| John | 15 | X-11 |
| Mark | 3 | X-12 |
| John | 4 | X-13 |
| Philip | 15 | X-11 |
| Mark | 15 | X-13 |
| Philip | 3 | X-15 |
Do you guys have an idea?
Have a good day
