Create chart to show the min, max, avg and sum on the time_taken column

[#1]

Can any one help out on this.

I want to prepare line chart and pivot table for the below data.

My dimension field is session_name

expression field is time_taken

i need to do the analysis like session_name wise, between the period and between the hours etc.

over all max

over all min

avg value

the same between the specified time period, etc.

FOLDER_NAME	SESSION_NAME	ERROR_MESSAGE	RUN_STATUS_CODE	START_TIME	END_TIME	SESSION_TIMESTAMP	TIME_DIFFERENCE	Time_Taken	YYYY	MM	DD
DOCUMENTUM_LZ	s_m_CB_COUNTRYML_LZLoad		1	4/17/2011 0:30	4/17/2011 0:30	4/17/2011 0:30	0 HOURS 0 MINUTES 14 SECS	0:00:14	2011	4	17
DOCUMENTUM_RF	s_m_ECIS_DR_CEDENT_DM1Load		1	4/17/2011 0:33	4/17/2011 0:33	4/17/2011 0:33	0 HOURS 0 MINUTES 8 SECS	0:00:08	2011	4	17
ABC_LOAD	s_m_ABC_SESS_LOG_PostChk_Load		1	4/17/2011 0:35	4/17/2011 0:35	4/17/2011 0:35	0 HOURS 0 MINUTES 46 SECS	0:00:47	2011	4	17
DOCUMENTUM_LZ	s_m_EC_CIS_NUMBER_XREF_LZLOAD		1	4/17/2011 3:31	4/17/2011 3:31	4/17/2011 3:31	0 HOURS 0 MINUTES 22 SECS	0:00:22	2011	4	17
ABC_LOAD	s_m_ABC_SESS_LOG_PARAMETER_Load		1	4/17/2011 3:33	4/17/2011 3:33	4/17/2011 3:33	0 HOURS 0 MINUTES 4 SECS	0:00:04	2011	4	17
ABC_LOAD	s_m_ABC_GROUP_MASTER_LAST_START_DT_UPD		1	4/17/2011 16:00	4/17/2011 16:00	4/17/2011 16:00	0 HOURS 0 MINUTES 3 SECS	0:00:03	2011	4	17
DOCUMENTUM_AL	s_m_GRLA_LH_CONTRACT_LZALoad		1	4/17/2011 16:01	4/17/2011 16:01	4/17/2011 16:01	0 HOURS 0 MINUTES 8 SECS	0:00:08	2011	4	17
DOCUMENTUM_AL	s_m_GRLA_LH_CONTRACT_LOB_LZALoad		1	4/17/2011 16:01	4/17/2011 16:01	4/17/2011 16:01	0 HOURS 0 MINUTES 7 SECS	0:00:07	2011	4	17
DOCUMENTUM_AL	s_m_GRLA_LH_SUB_CONTRACT_LZALoad		1	4/17/2011 16:01	4/17/2011 16:01	4/17/2011 16:01	0 HOURS 0 MINUTES 4 SECS	0:00:04	2011	4	17
ABC_LOAD	s_m_ABC_SESS_LOG_PARAMETER_Load		1	4/17/2011 16:01	4/17/2011 16:01	4/17/2011 16:01	0 HOURS 0 MINUTES 2 SECS	0:00:02	2011	4	17
DOCUMENTUM_AL	s_m_GRLA_LH_CONTRACT_DEL_Load		1	4/17/2011 16:01	4/17/2011 16:01	4/17/2011 16:01	0 HOURS 0 MINUTES 8 SECS	0:00:08	2011	4	17
DOCUMENTUM_AL	s_m_GRLA_LH_LOB_DEL_Load		1	4/17/2011 16:01	4/17/2011 16:02	4/17/2011 16:02	0 HOURS 0 MINUTES 5 SECS	0:00:05	2011	4	17
DOCUMENTUM_RF	s_m_GRLA_LH_DR_CEDENT_DM1Load		1	4/17/2011 16:02	4/17/2011 16:02	4/17/2011 16:02	0 HOURS 0 MINUTES 6 SECS	0:00:06	2011	4	17
DOCUMENTUM_RF	s_m_UPD_GRLA_LH_CHG_DR_CONTRACT_S_DM1Load		1	4/17/2011 16:03	4/17/2011 16:03	4/17/2011 16:03	0 HOURS 0 MINUTES 7 SECS	0:00:07	2011	4	17
ABC_LOAD	s_m_ABC_SESS_LOG_Load		1	4/17/2011 16:03	4/17/2011 16:03	4/17/2011 16:03	0 HOURS 0 MINUTES 31 SECS	0:00:32	2011	4	17
Application_Integration	s_M_SUBMISSION		1	4/17/2011 16:20	4/17/2011 16:21	4/17/2011 16:21	0 HOURS 0 MINUTES 24 SECS	0:00:24	2011	4	17
Application_Integration	s_m_CS_SUBMISSION_Stage1Load		1	4/17/2011 16:21	4/17/2011 16:21	4/17/2011 16:21	0 HOURS 0 MINUTES 8 SECS	0:00:08	2011	4	17
Application_Integration	s_M_SUBMISSION		1	4/17/2011 16:25	4/17/2011 16:25	4/17/2011 16:25	0 HOURS 0 MINUTES 13 SECS	0:00:13	2011	4	17
Application_Integration	s_M_SUBMISSION		1	4/17/2011 16:30	4/17/2011 16:30	4/17/2011 16:30	0 HOURS 0 MINUTES 13 SECS	0:00:13	2011	4	17
Application_Integration	s_m_SUBMISSION_GStarLoad		1	4/17/2011 16:32	4/17/2011 16:32	4/17/2011 16:32	0 HOURS 0 MINUTES 3 SECS	0:00:03	2011	4	17
Application_Integration	s_m_CS_RISK_Stage1Load		1	4/17/2011 16:41	4/17/2011 16:41	4/17/2011 16:41	0 HOURS 0 MINUTES 3 SECS	0:00:03	2011	4	17
Application_Integration	s_m_SUBMISSION_GStarLoad		1	4/17/2011 16:47	4/17/2011 16:47	4/17/2011 16:47	0 HOURS 0 MINUTES 3 SECS	0:00:03	2011	4	17
Application_Integration	s_M_SUBMISSION		1	4/17/2011 16:56	4/17/2011 16:57	4/17/2011 16:57	0 HOURS 0 MINUTES 14 SECS	0:00:15	2011	4	17
Application_Integration	s_m_CS_RISK_Stage1Load		1	4/17/2011 16:57	4/17/2011 16:57	4/17/2011 16:57	0 HOURS 0 MINUTES 3 SECS	0:00:03	2011	4	17
Application_Integration	s_m_CS_SUBMISSION_Stage2Load		1	4/17/2011 16:58	4/17/2011 16:58	4/17/2011 16:58	0 HOURS 0 MINUTES 3 SECS	0:00:03	2011	4	17
ABC_LOAD	s_m_WORKFLOW_RUN_HISTLoad		1	4/17/2011 17:00	4/17/2011 17:00	4/17/2011 17:00	0 HOURS 0 MINUTES 17 SECS	0:00:18	2011	4	17
Application_Integration	s_M_SUBMISSION		1	4/17/2011 17:02	4/17/2011 17:02	4/17/2011 17:02	0 HOURS 0 MINUTES 14 SECS	0:00:14	2011	4	17
Application_Integration	s_m_CS_SUBMISSION_Stage1Load		1	4/17/2011 17:07	4/17/2011 17:08	4/17/2011 17:08	0 HOURS 0 MINUTES 4 SECS	0:00:04	2011	4	17
Application_Integration	s_m_CS_SUBMISSION_Stage1Load		1	4/17/2011 17:12	4/17/2011 17:13	4/17/2011 17:13	0 HOURS 0 MINUTES 4 SECS	0:00:04	2011	4	17
Application_Integration	s_m_SUBMISSION_GStarLoad		1	4/17/2011 17:21	4/17/2011 17:21	4/17/2011 17:21	0 HOURS 0 MINUTES 2 SECS	0:00:02	2011	4	17

Thanks.....

Regards

Gangadharan M