Sum all from graph.

[#1]

Hello guys,

I have problem to show in text(in presentation) the total of no ticket for all parcel. now i'm just using count(parcelid) to come out the graph. any ideas to sum the num from the graph attach. thanks.

[swuehl · Accepted solution]

Try using an advanced aggregation (i.e. aggr() function), maybe:

=sum( aggr( count(parcelid), location))

where location is the field you used as dimension in your chart (needs to be a field, no calculated dimension).

Hope this helps,

Stefan

[#3]

Thanks bro.

U help me well....