Text Box Expression

[#1]

Hello,

I've a text box, with current expression as "=max(aggr(count(Total_Number),[group_tour]))"

And the output was " 102820 " , which is correct.

However, I would like it to be percentage instead.

According to my chart, 102820 is actually = 18.06% , which is also the largest portion in the chart, group_tour.

But how do I change the the output from 102820 to 18.06% , so that it corresponds with the chart?

Thank you!

[Anonymous]

Hi Daphnegxy,

Could you please share an example.

Regads,

[eduardo_sommer]

Hi,

Try

=num(max(aggr(count(Total_Number),[group_tour])) / count (Total Total_Number), '#0,00 %')

Eduardo

[#4]

Thank you for your reply! However, this solution didnt work 😞

It gave me a percentage, however the percentage wasnt 18.06%, like what i would see in the chart "group_tour" 😞

[eduardo_sommer · Accepted solution]

Is it possible to share your app?

Try also a modification to my earlier expression:

=num(max(aggr(count(Total_Number),[group_tour])) / count (Total_Number), '#0,00 %')

I took the Total from the second count. Maybe you have some selections, then the Total would ignore them.

Eduardo

[#6]

It worked!! Thank you so much!!