jaeW_at_Onyx Coach 
-
Re: How to use query-data command of domo CLI
make sure to use the help command... query-data -i <dataset_id> -xf <export_filename> -sql "SELECT AVG(avgHeartRate) AS heartRate, activityName FROM `{dataset_id}` WHERE avgHeartRate…1 -
Re: Why it doesn't filter as I expected
Domo does not handle NULL values well in Analyzer Create a beast mode case when `card Title` is null then '-- no card title--' else `card Title` end then you can filter on '--no card title--' hope th…1 -
Re: How to Determine When Returned Orders Have Been Fulfilled
https://www.youtube.com/watch?v=ZPf41Fjn1H8&t=523s Here you go! I did a tutorial on this topic a while ago on youtube. The term you're looking for is a cumulative sum (sorry if that sounds pedant…1 -
Re: How to Determine When Returned Orders Have Been Fulfilled
Having taken a closer look at your data though ... it's unclear if your 'ordered' column is total order amount or just new quantity of units ordered in that month. if your data just calculates 'order…1 -
Re: Table Subtotal not calculating beast mode
interesting. I'll be honest I didn't test this, but I'm pretty confident the pivot table is acting as expected. In your math, ignoring the adjustment to change units from year to months, you've said …1
