jaeW_at_Onyx Coach 
-
Re: Can you create a Summary Number that shows a subtotal percentage?
@Joe_M , it sounds like you'll need a window'ed function to build out the metric you're looking for. You may have to check with your CSM to get 'window functions enabled in beastmodes' before you can…1 -
Re: Percent Change Month to Month
Hey @Whimzyy , I recommend you try to put your report together in table builder first b/c this might require some experimentation. given that you're trying to do count(distinct) things can get hairy,…1 -
Re: Changing a Column from Measure to Dimension
https://www.youtube.com/watch?v=9HYx1vn3HRM It's a little bit of work, but you can alter the schema of your Fusion using the JavaCLI. Here's a link to a tutorial where i rename a column but you can a…1 -
Re: Create a list of months between two dates
you need a table with a list of numbers or a table with a list of dates (a date dimension would be easier) Then you can... SELECT f.* FROM Transaction t JOIN Date d ON d.date BETWEEN t.StartDate and …1 -
Re: Connector & DataSet Issue
Kev, Here's the official Domo KB. https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow Start with that. The notes I've added guarantee that you …1
