Sorry, final question. I have created a visual using “customer name” from table A and “count of thing” from table B where table B is linked downstream from table A in the data model. This visual works in that it provides an answer BUT it is missing “customer name” where “count of thing” = 0 and I want to show the customers in the visual who have 0. It is as though the link in the data model is doing an inner join instead of a left join. Is this something I should be able to solve?

Hi Jamie, have you tried using the option

Show missing values

when adding the attribute (Customer name, in this case) in the Analytical Designer? See the screenshot! Another option would be to use the IFNULL statement in the metric definition to ensure any null values are displayed.

thanks I’ll explore that