Benchmark Set Analysis between Outlets

[dominikkeller]

Hey Guys,

im trying to build a benchmark expression.

My Goal is to display the AVG Productivity from all Outlets  from a Group. 

So i select a outlet and a timeframe and the avg should deselect the outlet but not the timeframe. 

If i do a set analysis with "Outlet=" my Outlet Dimension shows me all outlets.

This is my expression for the value of the selected Outlet: 

sum(Buchungen.Summe)/(sum(GX_Stunden_Ready.minutes)/60) 

And my Selections

Any ideas to solve my Problem?

[sunny_talwar]

I am not completely sure I understand your requirement? Are you looking to ignore selection in Outlet? What was wrong when you ignored selection in Outlet after you used {<Outlet =>} in your expression?

[dominikkeller]

Hey Sunny,

if i use '=' in the set analysis this happens

My Goal instead will look this way

i hope you understand my weird thinking better now

[sunny_talwar]

I am still not certain, I understand completely here... why do these value match up exactly? Is that by chance?

[dominikkeller]

That was just a quick copy and paste placeholder in Excell.

In the first expression, it is calculated based on the selection.

sum(Buchungen.Summe)/(sum(GX_Stunden_Ready.minutes)/60) 

 In the second formula (my problem) the AVG of all outlets of the same group.

[sunny_talwar]

May be this

If(Column(1) <> 0, Sum(TOTAL {<Outlet>} Buchungen.Summe)/(Sum(TOTAL {<Outlet>} GX_Stunden_Ready.minutes)/60))

[dominikkeller]

thank you!

unfortunately not

this is the result

and i need the values from total, just without displaying the other outlets

[sunny_talwar]

It might be easier to help if you are able to share a sample to help you better here

[dominikkeller]

Of course

[sunny_talwar · Accepted solution]

Try this

Sum(TOTAL <Kalendar.Wochentag> {<Filiale.Filiale>} Buchungen.Summe)/(Sum(TOTAL <Kalendar.Wochentag> {<Filiale.Filiale>} GX_Stunden_Ready.minutes)/60) * Avg(1)