i have the below dimensions: cluster dimension,destination location dimension,origination location dimension,destination ip dimension,origination ip dimension, date dimension and measure : call duration.
for example consider the below sample data..
destination location - L1
origination location - L2
destination ip - 10.103.23.45
origination ip - 22.214.171.124
duration - 20
destination location - L2
origination location - L3
destination ip - 10.1.23.87
origination ip - 126.96.36.199
Now i need to calculate the percentage call duraion across cluster c1,destination location-L1,origination location-L2, destination ip-10.103.23.45 and origination ip-188.8.131.52----
so i should get as below--(duration across the above criteria/total duration)*100 ie., (20/20+30)*100.
but the issue am facing is, in awm for the denominator am getting the total duration as 20 itself instead of 20+30. the entire duration is not getting added. how do i get the entire duration? since i have 3 dimensions to be considered, i dont know how to use share measure.
i need to calclutate the total duration. can anyone pls help me out??