Best Of
Re: Magic ETL Join visual feedback (summary of join results)
THIS IS A SICK IDEA! LOVE IT WOOOOO
Re: Hi I had question about a basic beast mode calculation that is not behaving correctly
@Utz I generally recommend aggregating the numerator and denominator when using division in Beast Mode like this:
sum(`DeliveredMarginDefine`) / sum(`QtyMarketingForecast`)
Otherwise, the card is dividing each dataset row first before then summing them, resulting in unexpected outputs.
Re: Improve Readability for Long Column Headers in Color Rules Dialog
This is needed in various other dropdowns like the Save As for cards, dataset selection etc. Any dropdown for dataset or dashboard selection should be much wider. For dashboard dropdowns, the dialog could wrap by separating the names of each sub-dashboard onto a new row underneath the top dashboard.
Re: Easiest way to replicate an entire dataset lineage
You can create copies of datasets and dataflows:
With the copies you could then swap them out in the ETLs/views. Does that accomplish what you are trying to do?
Re: App Studio - Limits for Control Filter Options (Please!)
Yes, I would love more control over the "control" menu! I end up adding so many filter cards to my apps because I know the control menu will be too hard to navigate, which isn't the best use of screen real-estate when there's a built in, collapsible menu that should do that for me.
You should submit this post as an "idea" so that people can upvote it.
Re: sum based on distinct in another column
I added an indicator in the dataflow. Every code when it is the first time presneted in the data, the indicator is 1, then I sumed up based on this indicator.
sum(
case
when `code_indicator` = 1 then `mc_spend`
else 0
end
)
WizardOz
Re: Is there a best practice for a visual indication that a card has a drill down configured?
If you are on Windows OS, then:
Windows Key + Period will open an emoji keyboard and then you can enter it inline as text.
👇
🔻
👆
Re: Unable to export card in .CSV format
What is the name of the DataSet and card? Is it all cards on this DataSet that are experiencing the issue or just certain ones? I've run into issues exporting when certain characters are used in the name like brackets.
Domo often has more helpful error reporting in the API response than is displayed to the user. Can you look at the API response and see if there is a more helpful error message? You can do this by opening developer tools (right click in your browser, then click inspect), going to the network tab, repeating the export action on the card in Domo, then looking for the API request and response (it'll be from /api/content/v1/cards/<card_id>/export and might be highlighted red).
brycec
Re: Beast Mode Editor - Comment Out Lines
You can comment out blocks of code with "/*" and "*/".
Not as easy as highlighting a block of code but much faster than having to comment each line out individually.
Re: Allow manual refresh of Cloud Amplifier / Federated dataset schema
This is so much needed. We would appreciate the Domo team enhancing this or providing an alternative solution.
I often fix tables in Databricks, and I want those changes to be reflected in cards. I cannot find a way to refresh manually other than waiting until it refreshes itself.