Best Of
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.
Data format from Jupyter to Dataset
I'm facing the issue of transforming the dataframe to domo dataset.
I have cleaned dataset, merge, join etc and make my dataframe beatifull, then the issue happen when I export by the domo.write_dataframe, the domo dataset change the the format of dataframe and it definitely not what I want.
What a waste if we have to transform data again, right?
Anyone facing or have solution for this will be appreciated.
Here is the screen shot for some fields.
Re: Data format from Jupyter to Dataset
I was having a similar issue with a date column that changed to text when I wrote the data frame to a dataset in Domo. I played with the different dtypes, and found one that did stay as a date after moving to Domo (though the timezone changed, so it ended up being a few hours different than what I had in Pandas). Domo doesn't have an int data type, so maybe try changing it to a float to see if gives you something numeric once it's in Domo?






