Forum Discussion

ajeyschune's avatar
ajeyschune
Frequent Visitor
6 years ago

FIltering Adobe Metrics in Power Query

I am running into an issue where my Adobe query is pulling back too many rows of data, causing me to get the "Table is blank" error. I am trying to get daily UV and Visit counts for different campaign codes, and currently the query is pulling back a row for every campaign code defined in my segment even if there are 0 UVs/Visits on a given date. Is it possible to have my query filter out campaign codes that have a Visit or UV count =0 on a given date, so I am not pulling in unecessary rows into my results and causing the query to fail?

 

            {Cube.ApplyParameter, "DateRange", {#date(2020, 1, 1), #date(Date.Year(DateTime.LocalNow()), Date.Month(DateTime.LocalNow()),  Date.Day(Date.AddDays(Date.From(DateTime.LocalNow()), -1)))}},
            {Cube.ApplyParameter, "Segment", {{"s300000384_5ea07884c897672e4e96a530"}}},
            {Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},
            {Cube.AddAndExpandDimensionColumn, "evar1", {"evar1"}, {"(v1) Internal Campaign Code"}},
            {Cube.AddMeasureColumn, "Unique Visitors", "uniquevisitors"},
            {Cube.AddMeasureColumn, "Visits", "visits"},
            {Cube.ApplyParameter, "Top", {10000, "evar1"}}

 

"tab