Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi
Try below expression in "Number of Loads per month" chart
=Sum({$<Your_Month_Field= >}Your_Loads_Field)
hope this helps
Hi Colin,
Yes, that worked. Thank you
Can you flag the correct response as this will help other users looking for a similar answer.
Thanks.
Colin