Best Of
May 2024 Domo Release
If you logged into Domo today, you should have seen a preview of the new features and enhancements and betas coming to Domo next week. As I started doing earlier in the year, posting a PDF here since those messages disappear
once you read them. Enjoy.
Re: Lag() function for previous value over unpredictable rows counts of each partition
@ColemenWilson I realize now my blunder in replicating your perfect solution.
Apologies for the extra work there. I made a copy of the ETL from scratch using your solution, and it worked. I went back to the original and realized I had messed up the Rank and Window, by Ordering the function on Quarter instead of MonthYear .
Thank you once again. I see you're in UT, I used to work for BEN Labs up there. Look them up if you ever want a change of scenery from Henry Schein (I looked you up, impressive stuff ;) ).
I wish I could buy you a beer as a thank you!
Re: can anyone point me to the solution on how to build the following year to date vs previous year?
it works, LY is working the way I need it
the calculations are:
Previous Day (LY)
SUM(CASE WHEN DATE(Simple_Date) = DATE_SUB(DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY), INTERVAL 1 YEAR) THEN TotalRevenue END)
WTD (LY)
SUM(CASE
WHEN YEAR(Simple_Date) = YEAR(CURRENT_DATE()) - 1
AND WEEK(Simple_Date) = WEEK(DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR))
AND Simple_Date < DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR)
THEN TotalRevenue
END)
MTD (LY)
SUM(CASE
WHEN YEAR(Simple_Date) = YEAR(CURRENT_DATE()) - 1
AND MONTH(Simple_Date) = MONTH(CURRENT_DATE())
AND DAYOFMONTH(Simple_Date) < DAYOFMONTH(CURRENT_DATE())
THEN TotalRevenue
END)
QTD (LY)
SUM(CASE
WHEN YEAR(Simple_Date) = YEAR(CURRENT_DATE()) - 1
AND QUARTER(Simple_Date) = QUARTER(CURRENT_DATE())
AND Simple_Date < DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR)
THEN TotalRevenue
END)
YTD (LY)
SUM(CASE
WHEN YEAR(Simple_Date) = YEAR(CURRENT_DATE()) - 1
AND Simple_Date < DATE_SUB(CURRENT_DATE(), INTERVAL 1 YEAR)
THEN TotalRevenue
END)
the next step is to calculate the difference between the Current Year and the Last Year
Re: can anyone point me to the solution on how to build the following year to date vs previous year?
now, put all the totals together in a friendly way
Re: Drill Down Selector
Hi @DWill978 - as far as I know there isn't a way to drill to a specific path dependent on which column is clicked using Domo's out of the box features. I'm curious to hear if any other community members know of a way to do this though. I'm guessing there might be a way with a brick or a custom-app, but that is a lot more involved.
Re: Drill Down Selector
There is a way. In a past post I gave an example of creating a link that passes specific parameters to the page. I'll try to find it for reference.
Re: Adding custom font colors for a transposed row in a table
So this would require you to use an HTML table, which would mean restructuring your data because transpose isn't an option. But if you're really set on changing the font color instead of the cell color, you can achieve that by using this beast mode.
CASE
WHEN SUM(value) < 0 THEN CONCAT('<p style="color:red;">',SUM(value),'</p>')
ELSE CONCAT('<p style="color:green;">',SUM(value),'</p>')
END
Re: Period over Period with Non-Time X Axis
Awesome!! THat worked! Thank you Sean_Tully.
Disappointed that Domo doesn't offer that solution natively, but I knew there would be a workaround.
Re: Export on cards with embedded Domo Everywhere App Studio
I'll take a look - thank you!
Re: Unable to send message from Iframe to parent
@MattTheGuru Thanks for this.
I actually resolved this by just changing parent to top.
so it became, window.top.postMessage(), I think the issue was with parent and child iframe window.