Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
=Avg(Aggr(Avg(vTAT), MAR))
Test and confirm
Please find attached a sample application with the desired output:
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
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