-
How do I return a string column value from the MAX() of another column value?
Let's say I have the following: I want to group by the invoice # by dropping the SKU, returning the Product_Description of the MAX Product_Weight, and the SUM of the Product_Weight. With my given example I should return the following: I have tried in both Beast Mode and an ETL, but my Product_Description is never accurate.…
-
Do end users need a license to view Domo apps?
I just finished watching Domopalooza 2022 and was impressed with the features announced, but a question I still have is, do end users need a license to view a domo app? Our problem is that we have a limited number of licenses but want to distribute some of our visualizations to our salesmen. Is this possible with Domo…
-
Can I make a period over period pivot table with a dynamic date range?
I had a need to create a pivot table that has our % change ( this year sales - last year sales / last year sales). I was able to create an ETL that accomplishes this for any date this year. I am able to filter any date this year (MTD, QTD, YTD, etc.) and a beast mode will take the above formula to calculate my % change. I…
-
Is Magic ETL 2.0 able to handle more complex SQL injections?
Alright guys, I feel like I am going crazy. I have a beast mode card that works really well in calculating months on hand inventory. I am now trying to create an new ETL that does a group by vendor and I am trying to inject the same code. The issue is that 'Available Inventory' is always returning null for some reason. Is…
-
How do I add a stacked bar chart that shows month-to-date compared to last year?
I have a stacked bar chart that has each category broken down into available inventory, unavailable inventory, and on floor inventory. Basically I would like this chart to keep its format, but I would like to compare it with last year. The period-over-period charts that I have messed with have dramatically changed this…
