How to disable chart when number of records are less than a given number?

[#1]

Hi,

      In order to keep anonymity of the data, I was asked to stop showing data when number of selected records is less than 5. Is this possible? and how?

Thanks

Longmatch

[mambi]

you can try this as condition : GetSelectedCount(YourField)>5

[#3]

I think Mambi's method will work. You could add this as a calculation condition here:

You can then add a message so users understand why the chart's empty:

[maxgro]

in a chart you can use

- calculation condition in general tab

- show conditional in layout tab

with getselectedcount, getpossiblecount, count(somefield)

[#5]

Hi all,

       Thank you for your quick response. I tried your idea but it just did not work. Please refer to the file in the attachment. I think I must have missed something.

Longmatch

[#6]

Hi,

It does work but your selected user count needs to be greater than 4 for it to populate. See attached.

Matt

[mambi]

to get your chart working : you should have a listbox of userid then you must select more than 4 userid to get data displayed

[maxgro · Accepted solution]

when  there isn't UserID selected (ie after Clear)

GetSelectedCount(UserID) = 0

GetPossibleCount(UserID) = 25

count(UserID)=25