-
Precision Loss With Dataset APIs
Hi folks, I'm hoping to get some pointers on getting precise decimal data while using the Dataset export API. I ran a request to retrieve data for a dataset on my domo instance using the API docs and was able to get my file downloaded onto my notebook. However I'm noticing that the decimal fields seem to only be returning…
-
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…
