-
Regex Filters in Google Analytics?
Hello! I saw another post on this but I don't think that's what I was looking for. I'm trying to build a regex filter for the Google Analytics connector and I'm wondering how I can exclude a certain regex statement. This is what I have so far but I'm actually not sure what the operator should be. This filter is supposed to…
-
MySQL Recursion Performance/Speed Issues
Hello! I am looking for suggestions on how to improve the performance of my mysql dataflow. Currently I have a recursive dataflow built with a Google Analytics connector, and I'm using a concatenated key created by joining multiple columns together to delete and upsert new data from the historical dataset. I'm using the…
-
Dynamic Percentages of Total
Hello! I am trying to get a percentage total column to work within a beast mode calculation in a pivot table card. I'm using the OVER () function, but because I have dynamic date ranges in the table (ex: we're looking at last 30 days only) it seems to aggregate by the grand total instead, not considering date ranges. Is…
-
"Invalid Schema, Check Your Dataset Query" error
Hello, I only saw a few questions related to this on Dojo and figure I might ask. My dataflow has always ran fine (created in May 2021) but yesterday there was an error that showed up. I'm not able to preview the dataset, and I tried to refresh the ETL multiple times and reset the schema (deleted all columns from the…