Skip to Content
0

Max of count in webi report

Jan 10 at 01:15 PM

103

avatar image
Former Member

Hi,

I have data like this

Column

A

A

A

B

B

B

B

B

C

C

D

I need the result as B. Where it is counting and giving the maximum Value dimesion as the result.

Please help if any of them have answers

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

10 Answers

AMIT KUMAR
Jan 10 at 01:47 PM
0

create variable Show/Hide=If(Count([Column];All) In ([Column])=Max(Count([Column];All) In ([Column]))) Then "Show" Else "Hide"

Apply the filter on Show/Hide variable where value equal to Show to get the max value.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 11 at 07:50 AM
0

Hi Amit,

Thanks for the answer.

I created variable Top =Max(Count([column];All) ForEach ([column)). I am getting the count as 5 of the highest number which is correct. Can you please help get B instead of count as 5

Show 3 Share
10 |10000 characters needed characters left characters exceeded

have you tried with my solution.

With your Top variable you got the count 5 but i don't think so it's going to be 5 every time..may me next time it is 4 or 3.in that case creating other variable will not work.

0
Former Member

I tried that logic its showing blank if i put filter in the table as show.Please help

0

can you share your table screenshot.add the variable and don't include in the filter.After that check if values are populating correctly or not.

0
avatar image
Former Member Jan 11 at 11:04 AM
0

12.png

I have attached screenshot of the requirement


12.png (11.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 11 at 11:20 AM
0

everywhere its showing as Show only

Show 1 Share
10 |10000 characters needed characters left characters exceeded

follow these steps.Create Show/Hide variable

=If(RunningCount([Country];([Country]))=Max(RunningCount([Country];([Country]))) In ([Region])) Then 1 Else 0

After that apply filter on Show/Hide and where equal to 1.

0
AMIT KUMAR
Jan 11 at 11:30 AM
0

follow these steps.Create Show/Hide variable

=If(RunningCount([Country];([Country]))=Max(RunningCount([Country];([Country]))) In ([Region])) Then 1 Else 0

After that apply filter on Show/Hide and where equal to 1.


untitled.png (31.6 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

Can you please help me find the solution for the attached document

Thanks

Shamsolution.png

solution.png (22.8 kB)
0
avatar image
Former Member Jan 11 at 12:16 PM
0

Hi Amit,

Can you check the variable is this correct formula

=If(RunningCount([Country];([Country]))=Max(RunningCount([Country];([Country]))) In ([Region])) Then 1 Else 0

Show 1 Share
10 |10000 characters needed characters left characters exceeded

yes it's correct.what is the issue?

0
avatar image
Former Member Jan 12 at 10:47 AM
0

Hi Amit,

Thank you very much for the solution. I changed minor reset condition and it worked.

=If(RunningCount([Country];([Country];[Region]))=Max(RunningCount([Country];([Country];[Region]))) In ([Region])) Then 1 Else 0

Thanks once again

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 16 at 07:20 AM
0

Hi Amit

I apllied this formula:

=NoFilter(RunningSum([Amount];([[Country]];[Region])))

and used filter condition in table where it is 1

=If(RunningCount([Country];([Country];[Region]))=Max(RunningCount([Country];([Country];[Region]))) In ([Region])) Then 1 Else 0

Data is coming correct. But when i put report filter as YEAR its not working because of Nofilter.

Can you help me on this.

Thanks

Sham

Show 3 Share
10 |10000 characters needed characters left characters exceeded

why are you using nofilter on amount? if you filter on show/hide only then amount should sum up automatcially for max country & region.

0
Former Member

It worked Thanks. By using Nofilter it aggregates at the backend. Thanks

0
Former Member

Hi Amit

Can you please help me resolve the attached document.

Thanks

1.png (17.2 kB)
0
avatar image
Former Member Jan 17 at 03:46 PM
0

Hi ,

Can you please help me resolve the issue in webi

Thanks

Sham


1.png (16.0 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 15 at 04:22 PM
0

Hi Amit,

Can you please help me find the solution for the attached document

Thanks

Shamsolution.png


solution.png (22.8 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

if you apply filter on Show/Hide variable then amount will automatic sum..is not hppening?

=If(RunningCount([Country];([Country];[Region]))=Max(RunningCount([Country];([Country];[Region]))) In ([Region])) Then 1 Else 0

0