Stuck with aggregation

[#1]

Hi guys,

Hoping someone can help me here, is quite hard to explain but will give it a go.

I was looking for an expression to use in a line chart where the ITASTATS_Wave was a dimension. I wanted to show active responses for each wave defined by this formula:

sum(if(ITA_CHACTIVE=1 and ITASTATS_leaseCoHier=vLeaseco,1,0))

ITA_CHACTIVE gives 1  if parameters are met in the script for activity

What I was looking to do is to show the % of those active responses which are completely new for the ITASTATS_Wave.

Is it possible any help greatly appreciated

[MK_QSL]

Not understood properly... Can you provide some sample data?

[#3]

Could you please share your qvw?

[muniyandi]

can you post some sample file

[#5]

HI Guys

Have attached some sample data and another sheets with the results im trying to get to , I know there must be an easy way but so stuk

So wanted to check if an e-mail was responding to the wave for the first time  broken down by wave, so wanted to show first time responders for that particular vLeaseco, by wave.

Hope that makes sense.