Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can i display the total time take/ avg time taken in bar chart report

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;

bar_Chart.jpg

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Is it something like this you had in mind?

2018-01-24 23_28_49-Qlik Sense Desktop.png

View solution in original post

2 Replies
petter
Partner - Champion III
Partner - Champion III

Is it something like this you had in mind?

2018-01-24 23_28_49-Qlik Sense Desktop.png

Anonymous
Not applicable
Author

Yes i wanted something like this.

Thanks Petter, your app helped me a lot