I have figured out how to add a filter to my chart, is there a way that if I leave this filter null that it will display all data as opposed to no data?

This is the line I used to create the filter:

Paint_shop = :P9_Select_Shop

CodePudding user response：

Use

where (Paint_shop = :P9_Select_Shop or :P9_Select_Shop is null)