jaeW_at_Onyx Coach 
-
Re: Graphing a [Case Statement + Window Function] calculated field
i'm reading very quickly, but i'm pretty confident it won't work as set up. MY ASSUMPTION OF YOUR HIGH LEVEL GOAL A list of availabilities and the number of employees who have that xyz total availabi…1 -
Re: Beast mode: find most recent date for distinct ID and compare
re issue 1: use a LEFT JOIN to keep all rows from the LEFT side. then as you said, add an isMatch flag = 1 or 0 based on if it matched on the right. You could output them all to one dataset and then …1 -
Re: Graphing a [Case Statement + Window Function] calculated field
Magic will work in a pinch. Dataset Views will work as well. you can even construct your CASE statement within the DSV. NOTE. You CAN implement a window function inside the DSV, but be advised it can…1 -
Re: Time zone (bug)havior summary and questions
https://knowledge.domo.com/Administer/Specifying_Company_Settings/033Time_Zone_Issues_FAQ please review this document! it sounds like Domo is behaving as designed. if it's not, can you pls provide a …1 -
Re: Calculating the Running Maximum
@Crisocir be super careful with the aggregate functions particularly MAX() and COUNT(DISTINCT) OVER ... they will work for ONE card with an axis but as soon as you change the axis it'll probably yiel…1
