Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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 –
select STEP_NAME,
CREATED_DATE,
START_TIME,
END_TIME,
extract( hour from (END_TIME-START_TIME) ) ||'.'||extract( minute from (END_TIME-START_TIME) ) AS "DIFF"
from EOD_process;
Is it something like this you had in mind?
Is it something like this you had in mind?
Yes i wanted something like this.
Thanks Petter, your app helped me a lot