Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Charts

Hi Guys

i have used only() function in the chart expression  but i want that when user clear the selection he should be able to see the total data.??????

3 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try using the Aggr() in place of Only().

Regards,

Jagan.

rajni_batra
Specialist
Specialist

use max() instead of only()

regards

rajni

Not applicable
Author

Hi,

Use:

=if(GetPossibleCount(Field)=Count({1}Field), sum(Expression),sum({$<Field={$(=Only(Field))}>}Expression))

hope this hepl you

Regards,

Arun Goel