Best Of
Re: Is there a way to be notified if a dataset update is taking longer than "x" minutes?
Yes. You can use the Domostats dataset "Datasets History" to see the run times of your datasets and then create an ETL that calculates the average runtime and alert you when the run time is x% above the average run time.
Re: How can I make a series of goals on a stacked chart?
You could look at using an overlay chart:
You can also create a beastmode in a stacked bar chart that subtracts the actual from the goal and stacks the remaining amount ontop of the actual making the stacks dynamic. We do this for tracking our progress towards goal in our sprints:
We each have a different goal amount and the bar "fills up" as we progress toward that goal by subtracting the actual from the total goal to show the remaining amount towards goal. This could be a series of milestones by adding additional fields and adding them as series.
Would either of these solutions work for you?
Re: Workbench jobs retrieval
Your jobs are backed up by Domo for your specific machine that's running workbench. I'd recommend exiting out of workbench and launching it again to see your jobs or alternatively restarting your workbench server.
If you do want to export your jobs out of Workbench you can use the wb.exe executable located where you installed workbench as a command line interface. You can use the export-jobs command to export all of your jobs to a directory as JSON files. Note: If you re-import these JSON job definitions Workbench will create a NEW job and not overwrite the existing job (meaning duplicated datasets and jobs) even though the job ID is export as part of the JSON.
Re: Multiple Split Columns
@pauljames I noticed that you're using a spreadsheet upload as your input dataset. Depending on how often you need to upload the file, you could try using Excel's text to columns function to break out the columns before uploading to Domo.
Re: Multiple Split Columns
I had to do this recently where I had a column with 50+ splits. One thing I did to speed things up is shown in the below recording:
It's not perfect, but it does speed things up. From there I utilize the pivot/unpivot tiles to make the data more useable. Additionally with the pivot/unpivot tiles it doesn't matter how many column splits you have because they get transformed into rows.
Re: Beast Mode as Chart Label
I agree with Colemen. I lean toward the approach of stacking smaller gauges on top of a card to give an additional indicator about the visualization. Such as this where I have two smaller cards on top of a main card in a dashboard.
