Hi community,
My report contains user ids but they appear more than once on the report everyday and I want them to only appear once on the report. Is there a way I can filter them out in Looker such that they appear only once on these reports?
Hi community,
My report contains user ids but they appear more than once on the report everyday and I want them to only appear once on the report. Is there a way I can filter them out in Looker such that they appear only once on these reports?
Hey Syed, are your dimensions coming from multiple tables? If so, you might need a join in the LookML. Alternatively, if any values on the dupe line(s) for each user come back without a value, you could try filtering out results that are NULL from the Explore.