A question. I built a Warehouse Qliksense, this to measure how many pieces are picked by the employees, how many boxes are picked and how many pallets. Also in how much time this is all done. Now everything works splendidly.
There is only 1 issue.
I have a KPI that shows the total of boxes picked (Colli)
Now I need a KPI that shows the average of boxes picked for that weekday.
How might I achieve this?
I have a weekday dimension in my Calender.
The meaning is that if someone selects a date, say 25/04/2019 (a thursday)
Then they would see A number of total Boxes (Colli) Picked that day and next to it the average of picked boxes for thursdays.
