zcameron Contributor

This isn't an option that is currently available. Can I suggest that you add this to the Ideas Exchange? You can do that here.

Workbench is currently only available for Windows. There is a thread for this in the Ideas Exchange here, if you'd like to add your vote.

Is the Workbench service running using a user that has access to that network location? Also, it looks like the file you are looking for is on a mapped drive (O:). Depending on how the user is set up, it may not have that drive mapped for the service user. Can I suggest trying the UNC path instead of a mapped drive. For…

The latest version of Workbench is version 4, which includes the same functionality as 3, but has a brand new interface. If the txt file is delimited by a character, you can use the CSV file type to get it pulled in. For step by step instructions on getting data from a CSV file through Workbench 4, check out the article in…

The best way I've found to connect to MS Access data is through the Workbench tool. You can create an ODBC connection to an Access DB and then use that ODBC connection within Workbench to query the DB and push the data up to your Domo instance. If you aren't currently using Workbench, be sure to read the section in the…

Could you provide some more detail regarding the type of data you're trying to get into Domo? The Domo API is not in wide released at this point, but we may be able to find other ways to get your data into Domo. If it can be saved to a file, put on a sftp site, stored in google drive, box, etc., emailed as an attachment or…

Matt, Putting in a default value of 0 if there is not a match is something that can be done in the dataflow using joins and the IFNULL() function. We'll want to simulate a FULL OUTER JOIN by doing a LEFT JOIN and a RIGHT JOIN and then unioning them together. Here's a generic example: Assume we have two tables, table1 and…

In the last big release there was functionality added to the single bar, scatter, and a few other cards to include a regression line. It will use a least squares regression formula to create a trend line and superimpose it on your card. Maybe this would be a simple solution for you. To build one, create a Single Bar card…

It sounds like if you pull the summary data as one data set and the detail data as another, you can then use fusion or a dataflow to join the two tables together. The join can then happen automatically whenever either dataset is updated. Is that the behavior you're looking for?

There is a YouTube connector that you can request. If you reach out to your account executive, they can help you get it added to your Domo instance.

The date range isn't available as a variable or function in the beast mode. In some cases, though, you can use a datediff to figure out how many days the range represents. Here's an example: SUM(`login_count`) / DATEDIFF(MAX(`date`), MIN(`date`)) Not sure if this will fit your use case, but it's something you could look…

Can you provide a little more detail into what customization you are looking to do? If you can give an example, the community might be able to jump in to help.

Depending on the size of your dataset, you could use some nested queries to update the data. Here's an example that should work for the sample data you provided, supposing the columns are called `Date_Column` and `Value_Column` and are on a table called table_name: SELECT `Date_Column` ,CASE WHEN `Value_Column` = 0 THEN (…

Just to clarify, are you saying you'd like to see the daily summation divided by the count of all records on the dataset? If so, it would need to be done in a dataflow instead of beastmode, I believe. Beastmode calculations are done on a group by group basis. You can't reference an aggregation on the group (daily sum) and…

One of the great things about cards in Domo is their ability to dynamically group data based on a selected date grain. Your use case seems to be a good example of how to use that feature in a great way. If you set your date grain on the card to match your subgroup period ("by day" for example) and then choose "Average" as…

I would recommend creating the new dataset with the replace option and then use the "Switch cards to a different Dataset" option (see right side of image below) to shift your existing cards to use the new dataset. If your column names are the same in both datasets, it's a very straightforward process and takes a matter of…

Yes you can. Workbench can be run from the command line. Here's a link to the documentation: http://wiki.domo.com/confluence/display/428BA51/Running+Workbench+3+from+the+command+line Quick summary: wb queue-job --server <url> --jobid <id> where url is the server of your Domo instance (mycompany.domo.com) and jobid is the…

Tim, were you able to try out the solution I proposed? Did it work for you?

Steven, can you give an example of what you're trying to convert? Is it a string to a number, or something similar to that? Also, are you using a MySQL dataflow or something else? If you field is a string, but really has a number in it (e.g. '997') you can convert it on the fly by using it in a mathematical expression. For…

A Beast Mode is calculated on either a single record or group of records, depending on how the data on the card is being grouped. Because of that, the calculation doesn't have a way of reference other records. For example, I can't say, "I'm looking for the April average. Look back at other records that come before April…

A Treemap is a lot like a Pie chart in that it draws the areas of the shapes to correspond with the value that shape represents. Since you can't have a shape with negative area (at least not with the dimensions we know about ), there isn't a way to accurately represent a negative value on these types of cards. A Card that…

This is a good example of where data could need to be transposed or pivoted before you can get all the use out of it you'd like. That means taking your data like this: column header 1 column header 2 column header 3 5 6 7 6 4 13 3 7 4 And pivoting it to look like this: Value Series 5 column header 1 6 column header 1 3…

I hit this same issue. Until the fixed gets pushed out, a possible work-around is CASE WHEN LASTNAME LIKE 'O_Sullivan' THEN ... The "_" is a wildcard for a single character only. This will fail if a character other than an apostrophe could be between the "O" and "S", but will probably work for most specifica cases.