Best Of
Re: How can I calculate a percent of total in a Beast Mode?
Looks like a recent release allows this
Re: Income Statement
@jaeW_at_Onyx I was able to get to that part, but I am unsure how to create rows like Gross profit, where the calculation is not just sum, but subtraction of sum of cogs from sum of sales. Is there a way for me to create those different calculations for gross profit, operating income, income before taxes?
Re: Is there a way to duplicate a value one row down?
You can use the window function tile in Magic ETL. The function want to apply is LAG.
This article gives more info, scroll down to the Rank & Window Tile section:
Re: Domo Workbench Stopped Working
@donna_torrice - Domo stores your job definitions externally so if you're reinstalling Workbench they should re-appear after installation assuming the server information remains the same. If you're still worried about losing your jobs you can export your jobs in workbench before you do an upgrade however if you attempt to re-import these job definitions it will create new jobs and new datasets so you would need to clean up your instance. I've asked to have Workbench allow me to re-import the same definition and job id to avoid this but it hasn't been on the roadmap.
Alternatively if you need to install Workbench on a new server and do a migration you can follow these steps:
Re: Warning: Not all the data is shown | Calendar Card
You may need to pre-aggregate your dataset in an ETL as there's too much data for the chart to display.
Re: Can I revert data that I recently appended to my dataset?
On the history tab of the dataset, you should be able to go over the right and wrench will appear and you can choose "delete this update"
