Hi Guys,
I trying to obtain peak quareter hour in my data.
I tryed different formulas:
[Quarter Hourly] Where (Rank([TV_I];([Quarter Hourly]))=1) : Result #multivalues. even if i put in max() it`s still #multivalues…
I tryed with if else statement… but also unsuccesed…
Could someone help me?!?!?
Parahall 
(BOB member since 2010-12-20)
guys? anybody?
Parahall (BOB member since 2010-12-20)
Moderator note: Please do not bump your post until at least one business day has passed.
Marek Chladny 
(BOB member since 2003-11-27)
i tryed to do it`s in another way:
[Hourly] Where ([Total Traffic] = Max([Total Traffic] In ([Hourly])))
and i still recieve #multivalues…
[Hourly] it`s time.
and i want to put single value in text lable and not using ranking in table that affect on the whole table
Could anybody help me here?
Parahall (BOB member since 2010-12-20)
This formula is working :
=[Quarter]Where([Indicator]=Max([Indicator] ) In Report)
Be carreful where where you put the In operator
Max([Indicator] ) In Report) not equal to Max([Indicator] In Report) )
Then you need to adapt it if you have many dimensions (max quarter for each day …
Can you try ?
mathieuBO (BOB member since 2011-01-06)
i tryed the following formulas:
=[Hourly] Where ([Total Traffic]=Max([Total Traffic]) In Report)
=[Hourly] Where ([Total Traffic] In ([Hourly])=Max([Total Traffic]) In ([Hourly]))
=[Hourly] Where ([Total Traffic]=Max([Total Traffic]) In ([Hourly]))
=[Hourly] Where ([Total Traffic]=Max([Total Traffic] In ([Hourly])) In Report)
and all of them bring me #multivalues…
Parahall (BOB member since 2010-12-20)
I think the first one should work.
Do you have an aggregation property on your indicator [total traffic] ?
It could be due to multiple value for the same hour…
Or maybe you have two hour with the same max traffic…
mathieuBO (BOB member since 2011-01-06)