jaeW_at_Onyx Coach 
-
Re: Grouping by client_id without losing row data
if you want to calculate livetime value. In ETL you can GROUP BY Client ID and sum(Amount) then JOIN that back onto the transactions. OR you can use a RANK & WINDOW function to calculate cumulati…1 -
Re: Running Total Year over Year
you can do a cumulative sum using Rank & Window SUM(SUM(`Amount`)) OVER (PARTITION BY YEAR(`Date`) ORDER BY `Date`) but at the moment you cannot do a Subtotal in Rank & Window. To do this equ…1 -
Re: Updating a DataSet Triggered by the Finish of a Glue Job
@GrantSmith , you'd use the CLI to start the execution of the dataset in Domo. presumably, the trigger would be the completion of the Glue job.1 -
Re: Business in a Box Access
It's a feature switch. Talk to your CSM or email support@domo.com2 -
Re: Data Aggregation issue in the Beast Mode Calculation while using Sub-Total and Header Row.
@NFSharma i like what you tried to accomplish here. small feedback to improve engagement. when possible make it visual. when I was learning about the difference between aggregating row by row versus …1
