jaeW_at_Onyx Coach 
-
Re: How can i write this sql statement in domo?
@vikrao what's the business question you're trying to answer in plain english? i suspect it's something like "which users havent paid an invoice in the last x months. if so rework your filter as…1 -
Re: How is remove duplicate actually work?
RANK & WINDOW + Filter will initially output the same number of rows that came in. If Window Functions are not necessary, and you just need a SELECT DISTINCT equivalent, REMOVE DUPLICATES is OK e…4 -
Re: Listagg function or equivalent
You cannot Group_Concat in Beast Mode / Analyzer. You have to do this in SQL or Magic AFAIK1 -
Re: Allow tracking of Developer Token Usage
did you mean developer token as in developer.domo.com or access token as in domo -- admin -- access token? i think you'd want both and to be able to differentiate between both so users could track AP…1 -
Re: use fields from different tables group by date to calculate percentage
I would not get into the habit of JOINING fact tables this will lead to heartache and row growth. if you continue down this path you tend to end up with a ton of single use datasets that only work fo…1
