How do I remove duplicates from my report

[Syed3]

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?

[lindenPMP]

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.