Hello,
I want to evaluate the costs of an employee per hour. I know his time of arrival and his time of departure and what his wage per hour ist.
Now I want to visualize this in a bar chart, where I filter on a day. On the x-axis I have the hours of the day. The bars are as high as the costs of the employee in the particular hours.
For example: Anna arrives at 8:30 and leaves at 10:15. Her hourly wage is 20 €. The bar chart has 3 bars:
8: 10 €
9: 20 €
10: 5 €
I guess I have to multiply the rows in the script editor to have one row per hour with the corresponding salary. But I can't find a way to solve it. Do I have to use interval match? Or a loop?
I'm using Qlik Sense Version Feb 22.
Thanks in advance!