Set analysis to variables

[Anonymous]

Hi all,

I need to use a variable and  filter it with set analysis (in a pivot table) and I cant come to how to do it.

The variable is the calculation of a metric(Performance), all the fields of a particular dimension (Product Line) have one vale of the metric associeted. What i need is to calculate the average performance for 3 specific product lines (A , B , C), the 3 product lines together must be represented with 1 single name 'Total GSS' which its performance= avg(performance A , B, ,C ).

The variable is the following:

vCSAT=sum(TCE_RSLT_METRIC_CSAT_FLAG*if(vWithWeights=1,TCE_RSLT_WEIGHTS,1))/sum(TCE_RSLT_METRIC_CSAT_DSAT_TOTAL_FLAG*if(vWithWeights=1,TCE_RSLT_WEIGHTS,1));

As a dimension I am using:

'GSS'

expression:

// This is just a tryal, that is why i am only tring to filter by 1 Product Line. Nevertheless the objective is the descrived above.

avg({$<Product Line='A'>} $(vCSAT))

Thanks a lot for you time and help.

If something is not clear just ask it and i will answer asap.

Regards,

Lluís ^^

[Anonymous]

This is not working as GSS is not a dimension.

Thanks and sorry for the confusion! Hope that he new data helps!

[MK9885]

Not sure if this is correct...

Cus you don't have dimension as ='GSS'

I had to use Product Line as Dimension and added one extra variable

vWidthWeights =1

[oscar_ortiz]

What should the value of the variable vWithWeights be?

[oscar_ortiz]

Also, you don't have a column defined:  TCE_RSLT_WEIGHTS

What should the values of this field be?

[Anonymous]

it is 1 or 0 depending on a button that enables or disable the weight. TCE_RSLT_WEIGHTS is the weight (importance) assoscieted to each product line.

Sorry for not especifing before

Thanks

[oscar_ortiz]

That column doesn't exist in your sample data.

[oscar_ortiz]

Also, based on the data you provided what should your expected results be?

[Anonymous]

It is a value that defines the "importance".

Notice that when the variable vWithWeights=0, this whole column is not used, so it is not relevant for the problem. You can just omit it.

Thanks for your time

[Anonymous]

This should be the result

[oscar_ortiz]

Is that result based upon the sample data you provided?