Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Or, as an alternative and probably easier to read:
=if($(userid)=0,value,if(owner=$(userid) or user=$(userid),value))
Hi,
you could use as expression:
=if($(userid)=0,value,only({<letter={"=(owner=$(userid) or user=$(userid))"}>}value))
Regards,
Stefan
Or, as an alternative and probably easier to read:
=if($(userid)=0,value,if(owner=$(userid) or user=$(userid),value))
Excellent, thanks!