List box connections to objects

[#1]

Hi, I am making a dashboard with two graphs; one showing the number of loads transported per carrier, and one showing the number of loads per month, as you can see in the attachment.

I want all my listboxes to be connected to both graphs, except a listbox used to select the  month; I don't want this listbox affecting my graph with the number of loads per month.

How do I disconnect this listbox from the graph?

Thanks in advance.

Niek

[Colin-Albert · Accepted solution]

In the Number of Loads per Month chart, use a set analysis expression to exclude the month field from the expression.

     sum( {<[Month Data]= >} number_of_loads)

Obviously you will need to replace [Month Data] and number_of_loads with your actual field names.

Regards

Colin

[manideep78]

Hi

Try below expression in "Number of Loads per month" chart

=Sum({$<Your_Month_Field= >}Your_Loads_Field)

hope this helps

[#4]

Hi Colin,

Yes, that worked. Thank you

[Colin-Albert]

Can you flag the correct response as this will help other users looking for a similar answer.

Thanks.

Colin