Filter in Chart Totals

[#1]

Hi,

I have a set of data imported from SQL which looks like this:

FileName FileSize Summed

CP 1000 1

VP 2000 1

CP2 100 0

I want to display the data in a chart, so that when each file name is selected it shows the appropriate file size (easy), but where nothing is selected in the filter only the sizes where the Summed Column is 1 should be totalled. So in the case above the total file size would be 3000 (the CP2 file size is not summed, so not included in the total).

I have tried various If statements in the Expression but with no luck. Can anyone help?

[rwunderlich]

Assuming your Summed values are always 1 or 0, you've got a builtin Oleg-style flag to use. How about an chart expression like:

sum(if(GetSelectedCount(FileName) > 0, FileSize, FileSize * Summed))

-Rob