Best Of
Re: Dataset Tabs appear to be hidden for some datasets
I went ahead and submitted a support ticket, I will reply here once I get an answer. Thank you for the help @jessdoe
Jmoreno
Re: Domo Governance - Add Chart Type to Card Dataset
Commenting on this for people who were interested in voting this up.
Re: Reverting Back to the old dataset version
This only works if the dataset isn't the output from a dataflow, irrespective of recursion. So basically you can retrieve lost data via the history tab on any raw connector from the appstore, jupyter connectors, workbench connectors, etc.
Also, restoring a dataflow to a previous version and re-running the dataflow only restores lost data if the data loss was a result of the code change and the datasets powering the dataflow had not run/updated since the data loss.
jessdoe
Thoughts from Ben
Wanted to start a discussion where I can share a few things on my mind and people are free to ask questions.
Re: Customize email address in DataSet via Email Connector
In general, I think it's better practice to have a direct solution instead of a workaround. Contact forwarding introduces another potential point of failure, especially at scale.
I think user friendly names is a good idea. Because they would be using the custom domains, the duplication issue is not as prevalent as it would be. It would be (should be) pretty easy to just compare them to a DB and kick back an error for dupes.
Re: Pivot Table - Blank Column To Segment Data
For the blank field you can copy and paste an empty character as the title so "Blank" wont be displayed. And for the "Blank" field you can just put '' as the value in the beastmode and the 5 shouldn't show.
Re: Beast Mode: Syntax issues on filtering out a Sum Total
If you don't want ID='Liability' in your card, the easiest way is to drag ID into the filters section and choose Not In and select Liability.
If you need those values for other parts of your card, but don't want it for this specific value, you could try this beast mode as another option.
SUM(CASE WHEN Id<> 'Liability' THEN values END)
This would sum everything but ID='Liability'
Re: Beast mode to filter out certain ID field then sum the remaining IDs 'value'
Try this:
SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)
Re: Beast Mode: Syntax issues on filtering out a Sum Total
Try this:
SUM(values) - SUM(CASE WHEN Id= 'Liability' THEN values ELSE 0 END)