Hi team, we are experiencing an issue on reporting on 1-to-1s and 1-to-1 attempts (these are performance review records in our system) where, when we apply a "Team" or other user attribute as a filter, the tool is not showing all relevant records. In our data model, the relationship between 1-to-1s / 1-to-1 attempts and Teams goes through the User table. When there is no attempt submitted by a user, our expectation is to still see the issued 1-to-1s to those users. But when introducing any user related attribute or metric, the records get hidden. The metrics we are using are Count of 1-to-1 (based on 1-to-1 Id) and Count of 1-to-1 attempts (based on 1-to-1 attempt Id). I am sharing an image of our LDM - do you by any chance spot any evident issue that could cause this issue to happen? Thanks in advance 🙏

Hello Raffaella, What is the metric you are using to calculate this? I believe you need to be using a BY clause to correctly connect the datasets through explicit lifting, but it could also have to do with NULL values being present and you will need to push those through as well.

Hi Joseph, thanks for the response, the metrics would be: Count of 1-to-1 for all the records: SELECT COUNT({label/one_to_ones.id}) Count of 1-to-1 attempts (the ones submitted by users): SELECT COUNT ({label/one_to_one_attempts.id})

I believe you would want something like: Select Count(attribute) by the primary key of the users data set. I'm not entirely sure if this will work in your use case, as you are trying to work through a few different data sets.