Sum of Distinct Records

[#1]

Hi

Below is the sample data

Date	MAR	vTAT
2015-04-24	150424SCBLAU2SAXXX4495866032	1:13:41
2015-04-24	150424SCBLAU2SBXXX0123004002	63:41:27
2015-04-24	150424SCBLAU2SAXXX4495866033	65:52:23
2015-04-24	150424SCBLAU2SBXXX0123004002	63:41:27
2015-04-24	150424SCBLAU2SBXXX0123004002	63:41:27

Need to find the average of vTAT for DISTINCT MAR using Date as Dimension

Average should be around 43:35:50

It should be displayed as a BAR CHART

Regards

[sunny_talwar]

May be this:

=Avg(Aggr(Avg(vTAT), MAR))

[Anonymous]

Test and confirm

[sunny_talwar]

Please find attached a sample application with the desired output:

[#5]

Hi

Below is my Requirement

Dimension - > Date

Need to find the average of Time Diff between EndDate and Start Date for Distinct MAR

In the Attached file the average should be 45:35:50

Note: Source file attached as excel in Distinct Sum

Regards,

Senthil

[#6]

Hi

Below is my Requirement

Dimension - > Date

Need to find the average of Time Diff between EndDate and Start Date for Distinct MAR

In the Attached file the average should be 45:35:50

Note: Source file attached as excel in Distinct Sum

Regards,

Senthil