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)
