Discussion board where members can get started with Qlik Sense.
I have an EOD process that is run everyday for a number of steps, say 10 steps per day.
i store the start_time and end_time for every step in my EOD_process table.
i want to create a report in Qlik sense which will display the total time taken/average time taken for a step to execute a particular day.
i am not able to achive this in my bar chart as well as line chart report.
Can somebody help me with this?
Query to load data –
extract( hour from (END_TIME-START_TIME) ) ||'.'||extract( minute from (END_TIME-START_TIME) ) AS "DIFF"
Go to Solution.
Is it something like this you had in mind?
Yes i wanted something like this.
Thanks Petter, your app helped me a lot