Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi anand
can you attach some sample
If you have brand as your dimension, what happens? Do you not get the correct sentiment percentage mapped to the brand name.
The above table is showing the sentiment % of Brands.
But I need the Brand Name Which has maximum Sentiment % in a Text Box.
can you post a sample app.
can you please upload sample application?
Please find the attached application
But I want that We can also show the Brand Name without selection
Hello,
Did you try the IF statement.
If(Brand = max(aggr((count(Sentiment)/Count(TOTAL Sentiment))*100,Brand)), BrandName)
Thanks,
Angad
Thanks to all.
I found the solution . The solution is:-
MaxString(If(AGGR(Rank(count(Sentiment)),Brand)=2,Brand))