jaeW_at_Onyx Coach 
-
Re: How do you change the order date "2020-01-06T16:56:00" to the first day of the month?
@gbennett ,the problem is literally in the error returned, invalid column name. SELECT DATE(`order_date`) - INTERVAL (DAYOFMONTH(`order_date`)) DAY + INTERVAL 1 DAY AS giveMeAName ,SUM(`order_value`)…1 -
Re: Last Value Projection when Using Right and Left Value Scales
this is not the question you asked, but i strongly recommend you calculate your own projections in Domo using ETL. WHY. if you rely on a projection based on actuals data visualized in chart, you lite…1 -
Re: Does datafusion count against warehouse row count
AFAIK ... depending on who you talk to at Domo the answer may flip flop depending on where the stat is collected from. But I believe the correct answer should be Data Fusions DO NOT count. (I say thi…1 -
Re: Calculate average time to accumulate to a value.
ooof this was fun little challenge! https://www.youtube.com/watch?v=eifSYZIcPzg the short answer 1) you can't do it 100% as beast modes in Domo (you can get 75% there with window functions but it's n…1 -
Re: Pareto based on the higher percentage
@Steve-DOMOnoob sorry for being dense, what is the math you're trying to do? the pareto takes one axis and one measure... so if you take sum(CASE WHEN WARM ... then 1 else 0 END) / sum(CASE WHEN COLD…1
