Filter data with List Box when the expressions use Set Analysis

[eadbhard]

Hi there,

I have a line chart where the dimension is the month, and the chart has three expressions:

Expression 1   =Avg({$<Customer={'CUSTOMER NAME 1'}>} On_Time_Pct)

Expression 2   =Avg({$<Customer={'CUSTOMER NAME 2'}>} On_Time_Pct)

Expression 3   =Avg({$<Customer={'CUSTOMER NAME 3'}>} On_Time_Pct)

As you can see, each expression is selecting data for a specific customer. The chart works fine but now I want to add a List Box filter with the customer name.

The field  in the "Customer" List Box is the same field used in the expressions.

When I select a customer in the List Box, nothing happens in the chart. I expected the chart to show the data of the selected customer only.

So how can I filter by customer in this chart?

Thanks for any insight!

[dplr-rn]

Why not have customer as a dimension?

[sunny_talwar · Accepted solution]

I agree with @dplr-rn , but if for unspecified reason you have to use your current approach, then change your expressions to this

Expression 1   =Avg({$<Customer *= {'CUSTOMER NAME 1'}>} On_Time_Pct)
Expression 2   =Avg({$<Customer *= {'CUSTOMER NAME 2'}>} On_Time_Pct)
Expression 3   =Avg({$<Customer *= {'CUSTOMER NAME 3'}>} On_Time_Pct)

[eadbhard]

@sunny_talwar Worked like a charm! Thanks a lot.

[eadbhard]

This approach also work wonders. For other new users like me:

• Add the Customer as a Dimension
• Leave one Expression only
• Remove the Set Analysis query from the expression

Great answer, thanks!