5 Replies Latest reply on Feb 19, 2016 6:27 AM by Danilo Drobac

    How do I only show data that exists in both values of given dimension

    Danilo Drobac

      Hi there,

       

      This is quite a tricky one to give a title to, but the problem should be fairly simple (it took me less than 1 minute to do the same thing in Excel).

       

      I've created a table which is split by search queries, and I have a "Week" dimension which I'm splitting the metrics out by. In this specific table, I want to only show the queries which appear in both of the dimensions. I've attached a screenshot of what I have at the minute, but the outcome I'm expecting is for there to be no instances where there are nulls in either side of the table.

       

      I really hope I'm just being stupid and that this is an easy fix, I've been at it for an hour already!

       

      Thanks

      Dan