Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a variable named as vTAT
I have to find the sum of vTAT based on DISTINCT MAR
MAR vTAT
123454 1:23
123454 1:23
123456 4:15
1234566 5:17
Regards
Senthil
Create a chart with dimension MAR and as expression
=sum(vTAT)
Or post your expected result..
Hi
or you can try
=sum(DISTINCT vTAT)
Hi
I want to show it in a BAR Chart with Dimension as Date , Expression as Avg of vTAT of DISTINCT MAR
Regards
Senthil
se tis,
tat:
Load * INLINE [
MAR,vTAT
123454,1:23
123454,1:23
123456,4:15
1234566,5:17
];
tat2:
nOCONCATENATE Load MAR,
SUM(vTAT) AS vTAT
resident tat
group by MAR;
Drop table tat;
Hi
I want to show it in a BAR Chart with Dimension as Date , Expression as Avg of vTAT of DISTINCT MAR
Hi, vTat is a variable? and what's the expression of the variable? Maybe this works if vTAT has the same value for the same MAR:
Avg(Aggr(vTAT, MAR))
Hi
Yes vTAT is a Variable
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
Regards
Hi, using "Avg(Aggr(vTAT, MAR))" returns 43:35:50, PFA.