RACERX ⚪️

About

Username
RACERX
Joined
Visits
2
Last Active
Roles
Member
Points
6
Badges
1

Comments

  • Piling on to this request. Use Case: We have a dashboard page built that (should) by default show "Last Month's Sales".. However, it would be nice if users could manually change the date range if desired to browser other historical sales data. The current solutions are: * Use a "hard" manual date range as a page filter.…
  • 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…
  • 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…
  • 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…
  • 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…
  • 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…
  • 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,…
  • 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…
  • 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…