RACERX Member

Comments

  • Hey Syed, RE: DateDiff Column -- Add a calculated field for DATEDIFF(CURRENT_DATE - `DayAccessed`) - it will give you the number of days between "today" and the value in the `DayAccessed` column. You can then add this calculated field to your table. RE: Date Formatting -- I'd personally recommend handling this at the ETL…
    in Filtering Dates to Get the Last Access Date Comment by RACERX November 2020
  • Thanks @jaeW_at_Onyx I appreciate the insight. My concern is more practical. Something worked well, was endorsed, was used to build hundreds of transformations, and ran flawlessly for quite some time. Now it does not for seemingly no real reason -- data size and schedules had no material change. Using a traditional flavor…
    in Redshift -- Significant Slow Downs Recently? (November 2020) Comment by RACERX November 2020
  • G, Is the virtually generated email address from Hubspot? If so, can you access the inbox in any fashion? For example, in Domo, you can change the DataSet-via-Email URL to manipulate it into downloading an email message. There have been several times where I setup a DataSet-via-Email job in Domo where the data source…
    in Automate Export and email Comment by RACERX November 2020
  • Hey Colin -- we had to solve for this exact use case at my office as well. Here are a few learning curve tidbits from my growing pains: * @Jamie is correct, the AppleTV app can work, but I had bad experiences with it. There were several cosmetic bugs and the behavior seems to be erratic. Her second suggestion of using a…
    in See a dashboard on a TV Comment by RACERX November 2020
  • At a high-level @GrantSmith is right -- mixing date dimensions is always tricky (in this case you have single day vs. multi-day range). The best thing to do is normalize the dates as much as possible. In your case I have a slightly different suggestion that sounds like it may solve your need. Can you try joining the…
    in Combining data sets without duplication Comment by RACERX November 2020
  • Not sure of specifics, but you could use a sub-query (MySQL/Redshift) or fork your MagicETL to filter for (roughly) `Your Data Date` <= CURRENT_DATE - '50 Data Days' then take an AVG of whatever the quantity column is. Once you have that, join it back to the main query or branch. Assuming your data updates daily/regularly,…
    in 50 day rolling average in ETL? Is it possible. Comment by RACERX November 2020
  • Jarvis sorry for necromancing the thread -- Domo Dev/Support sorted the 10k record limit. The issue going forward is that the native connector's "append" feature does not work. Append duplicates all data rather than add only new records (based on unique ID or timestamp, whatever). I have a bug open but it doesn't seem like…
    in Anyone Using Call Tracking Metrics (CTM / CallTrackingMetrics) Data Connector? Comment by RACERX November 2020
  • Hey - just jumping in to share a similar concern. I am having a similar row-count issue with a CRM provider CallTrackingMetrics (CTM / Call Tracking Metrics for search purposes). Basically the API Connector will fetch the most recent 10k rows, then stop. The problems I have are: A) With the 'Replace' update method - I…
    in 10k ft connector - limiting time entry approvals returned Comment by RACERX January 2020
Avatar