Gauge Chart at Site Level and area Level

[spikenaylor1]

I have fields

Document (text)

Documentcompleted (True/False -- 1/0)

Area (text)

I have created a gauge chart to give percentage of documents completed

expression is =num(sum(Documentcompleted)/Count(Documentcompleted),'#.##%')

How can I expression it as a site so it doesn't filter down, I want it to do the expression for all data always.

I have created charts for each area

1st one expression is =num(sum(Documentcompleted)/Count(Documentcompleted),'#.##%')

How can i set this to display all the time only for area 1.

i have a list box for the areas for other filtering on the data and when selecting area 2, I wish the 1st chart to only display data for area 1

[spikenaylor1]

Have got it working I think by

=num(sum({1<Area={'Area1'}>}Documentcompleted)/Count({1<Area={'Area1'}>}Documentcompleted),'#.##%')

This now shows the Documentcompleted % for the area regardless of any selection made.

I have a list box with year selection called LB05

How can I enable the Year selection within the expression but ignoring all other selections.

Am looking through the reference guide but still not getting anywhere yet.

Any help greatly appreciated

regards

Spikenaylor