Newbie question, restricting loaded data

[#1]

How should I use the input box in the attached file to restrict the bar chart to those records matching either the owner or user?  For example, if the value of the input box is 1, the chart should show letters a-e AND p-t, if the value is 2 the letters shown should be f-o.  If the value is 0, ALL the letters should be shown.

[swuehl]

Hi,

you could use as expression:

=if($(userid)=0,value,only({<letter={"=(owner=$(userid) or user=$(userid))"}>}value))

Regards,

Stefan

[swuehl · Accepted solution]

Or, as an alternative and probably easier to read:

=if($(userid)=0,value,if(owner=$(userid) or user=$(userid),value))

[#4]

Excellent, thanks!