Make filter options context aware

[WLS-D]

Hey @samellis

In that case I would try return something else in your ifelse like “No data”.

I would also recommend giving the solution in this topic a try:

How to remove the null option from control drop down

Hi @achourey, There are two possible options: If your Activity Type and Source have limited values that do not change; you could build your parameter as a static list of values, that match in content with your Fact table. This way you exclude Null from the list Alternatively, if you have dimension table for Activity Type and Source as well you could basically do a similar join with the factor table as you did with calendar table and use the columns from the dimension tables for the parameter. …