Best Of
Re: Magic ETL - Allow group by without a grouping column
@ChristianW - Yes exactly what I'm looking to do but you can't get it without adding a constant value to group on in the group by tile. SQL and Window Functions don't require a column to perform a grand total.
Re: Period Over Period Waterfall
This would be super helpful! When I've used waterfall charts for this type of analysis in the past, I've had to use Excel or a dataflow to structure the data the right way. It would be a huge time saver to be able to do this natively.
Re: Date Diff - Tenure
Alternatively you could utilize some math functions to simplify your beast mode to calculate just the tenure in weeks - this would allow easier filtering using a single numeric value:
FLOOR(DATEDIFF(CURRENT_DATE(), `dt`) / 7)
Re: Where can I find the logic for custom built dimensions?
Did you already click on the dataset name and then go to the lineage tab and work your way back inspecting each dataflow to when those columns are getting created?
Re: Chart Types Search in Analyzer
Love this, would also love FAVORITES to reflect the charts I personally use most often, rather than presets from Domo.
Re: Status of Ideas in Idea Exchange
It would also be nice to received a push notification if the status of something you have authored or commented on has changed!
Re: How to convert a Beast Mode with a CASE function in it into an aggregation?
what code are you writing?
SUM(CASE WHEN ... then AMOUNT END)
should work fine
Re: Getting a Sum of Values for X Days When There are Gaps in the Dates
I would suggest using the Domo Dimensions calendar dataset to create a dataset that has all the dates for a given time period. You can then left join this to your sku dataset and replace nulls with zero. Then use your rank and window tile to go back x days.
If you haven't used the Domo Dimensions connector, you can find it by going to Connectors in the Data Center and then search for Dimensions and choose Calendar.
Hope this helps.
Re: Getting a Sum of Values for X Days When There are Gaps in the Dates
Then I'd go the second option where you'd need to create a dataset with all of the possible SKU / Date combinations.
A starting point as @MarkSnodgrass mentioned is the Date dataset from the Domo Dimensions connector, filter out any future dates to speed up processing, add a constant of 1 can call it 'Join Column'.
Get a unique list of your SKUs and add a constant of 1 can call it 'Join Column'. Join these two together on the Join Column.
Take that resulting dataset and left join it to your dataset (yours is on the right side in the join tile) and then use the rank and window tile to calculate the 30 day rolling sum, then use the formula tile or calcuation tile to divide that by 30 to get your average.
PS. @MarkSnodgrass I beat you :)