How to get the doubles out of my dashboard selection

[Lucas_Cuypers]

HI all,

i was trying to get a dashboard where i first need to select the correct customer. As i am always working with slides some how even they are connected and the option is activated in the view, selecting them is not triggering the other views.

so i made a new slide where i got the customers in it with a virtual column. meaning all data was in the same “table” now.

when i do this the connection does work but i get the same customer more than once…
i just want every costumer only once, sorted from A to Z.

this is how it looks now…

so how do i achieve this ?

thanks

[Lucas_Cuypers]

Hi all,

i have made the virtual column a ref to the original costumer table.
by doing this i get the customer only once but the link even when they are in ref with each other does not work…

[Aleksi]

In generally you should have two tables… Customers and Orders. When the customer column in your Orders table is a ref, it should do the trick what you are looking for with interactive Dashboard.