Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to share sample data with days/dates (that you need on the axis). Even an excel would be helpful.