Sum of Distinct

[#1]

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

[swuehl]

Create a chart with dimension MAR and as expression

=sum(vTAT)

Or post your expected result..

[PrashantSangle]

Hi

or you can try

=sum(DISTINCT vTAT)

[#4]

Hi

I want to show it in a BAR Chart with Dimension as Date , Expression as Avg of vTAT of DISTINCT MAR

Regards

Senthil

[buzzy996]

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;

[#6]

Hi

I want to show it in a BAR Chart with Dimension as Date , Expression as Avg of vTAT of DISTINCT MAR

[rubenmarin]

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))

[#8]

Hi

Yes vTAT is a Variable

[#9]

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

[rubenmarin]

Hi, using "Avg(Aggr(vTAT, MAR))" returns 43:35:50, PFA.