I need Brand Name.

[#1]

max(aggr((count(Sentiment)/Count(TOTAL Sentiment))*100,Brand))

I am using the above expression and getting the maximum sentiment % of a Particular Brand but I want to find the name of the Brand which has maximum sentiment %age.

So ,Please Help me on this.

Thanks in Advance.

[#2]

Hi anand

can you attach some sample

[Anonymous]

If you have brand as your dimension, what happens? Do you not get the correct sentiment percentage mapped to the brand name.

[#4]

The above table is showing the sentiment % of Brands.

But I need the Brand Name Which has maximum Sentiment % in a Text Box.

[Anonymous]

can you post a sample app.

[senpradip007]

can you please upload sample application?

[#7]

Please find the attached application

[#8]

But I want that We can also show the Brand Name without selection

[#9]

Hello,

Did you try the IF statement.

If(Brand = max(aggr((count(Sentiment)/Count(TOTAL Sentiment))*100,Brand)), BrandName)

Thanks,

Angad

[#10]

Thanks to all.

I found the solution . The solution is:-

MaxString(If(AGGR(Rank(count(Sentiment)),Brand)=2,Brand))