Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
Why not have customer as a dimension?
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)
@sunny_talwar Worked like a charm! Thanks a lot.
This approach also work wonders. For other new users like me:
Great answer, thanks!