zcameron Domo Employee

Unfortunately, the desired result isn't possible in beast mode because each record will fall into exactly one category, which in this case appears to be the month. If a record is used in the January line point, it isn't also part of the group of records used to calculate the February line point. You could create a dataset…

Yes, Workbench can schedule jobs to automatically run, as long as the machine that Workbench is running on is up and running at the scheduled time. You can also receive notifications on success or failure of the jobs. Data pushed up from Workbench goes into a specified Domo DataSet. You define the dataset when you set up…

The Average function will ignore rows where the value being averaged is NULL. Because of this, you can switch your zeros to nulls and the average function should behave how you're expecting. Do accomplish this, you could try something like this: AVG( CASE WHEN (`Total Leads Completed`/`Total Leads`) > 0 THEN (`Total Leads…

You can add the column you want to sort by to the Sorting section in the card builder, then choose ascending as the sort order. It sounds like in your case you would like the ages in order across the x-axis. In that case, add the age column to the sorting section, choose Ascending as your order and then choose No…

PDP is used to limit records in the dataset, but doesn't have an option to remove or hide columns within the dataset. A couple of ideas you can use to prevent people from seeing certain columns: If you're end users have particpant level licenses, you can prevent them from seeing columns not included in your card by…

I'd recommend looking publishing options. You can get to them by going to the page of cards you'd like to share and clicking on the wrench menu in the top-right corner. From there you can choose to publish the page as a slideshow or export it as a powerpoint. If you choose to publish as a slideshow, going through the…

There isn't an option to color in an entire state based on a series because the normal map behaves more like a heatmap with color chosen by the value associated with that state. What you could do, however, is use the Latitude/Longitude Map to place dots and labels on the map for each state. You'd just need to join some…

This functionality doesn't currently exist in the Domo product. Can I recommend that you add this to the Ideas Exchange? I've found that the product team watches the Ideas Exchange closely and if something gets up-voted there, it's much more likely to make it into a future release of the product.

A beastmode calculation can be used as a filter, just not if it uses an aggregate function, such as SUM, AVG, MAX, etc. The reason for that is that filtering has to happen before aggregation. Filtering is meant to remove unwanted records so that calculations (aggregations) and visualizations don't include values you don't…

No, you don't need to run the ANALYZE command. Alternatively, you can also use the ALTER TABLE syntax like below: ALTER TABLE mr_table ADD INDEX(`mr_table_id`)

I'm not familiar with a method for pivoting the data in workbench. You can, however, upload the data as is and then use the Collapse Columns transform in Magic ETL to pivot the data and create a record for each Column A & Column B-Z combination. Could that be an option for your data?

Yes, you can change the schedule and save it. As long as you don't select Run Now, it will wait until the next scheduled time to run and pull your data in.

I've come up against this problem as well. It turns out that it is Salesforce, not Domo, that is imposing the limit. (See this thread in the Salesforce Developer community). The Salesforce API will only return 2,000 records for a saved search/tabular report. It will, however, pull any number of records from the tables…

Doing this in Workbench would depend on what type of data it is. Is it an ODBC connection, Excel spreadsheet, etc.? You could do this in Magic ETL after the data is in Domo. To do this, you could use the Select Columns transform to grab only the Firm column, then use a Remove Duplicates transform to narrow it down to…

If your instance set up that way, you're right. You'd need to rework the indexing on the substring to match how it's returning weekday values. Nice call.

Are you looking at it in beast mode or in SQL? WEEKDAY behaves a little differently in the two environments.

Creative! Is it giving you the result you expect? Depending on how you want it to behave, you could also flip the case to the other part of the expression like this: CASE WHEN HOUR(`CreatedDate`) < 17 THEN <ADD HOUR AND MINUTES TOGETHER> ELSE 0 END Which would say that if it falls before the end of the normal day, then…

I believe this function, written to work as a beast mode calculation, should get you what you're looking for: -- --------------------------------------------------------- CASE DATEDIFF(`end_datetime`, `start_datetime`) WHEN 0 THEN ROUND((HOUR(`end_datetime`) + (MINUTE(`end_datetime`)/60)) - (HOUR(`start_datetime`) +…

There are a number of ways to tie values in your data to colors on a visualization. Here are some examples: Sumo Card Conditional Formatting Sumo cards have conditional formatting built in. To access it, hover over the field name of the field to which you want to apply conditional formatting and you'll see three dots…

Depending on where the file is on the C:, the user may still not have access to it, especially if it is in a user's folder (documents, desktop, etc.). I think it would be a worthwhile test to change the user that is running the workbench service to a user that has access to the specific folder that you're pulling from…

When I'm troubleshooting a dataflow, my first step is to go to the details page for the dataflow. To get there, go to the Data Center and click the wrench menu for the dataflow you want to troubleshoot. Choose the "Details" option. From the details page, you can see the history of the attempted runs of the dataflow. If it…

This sounds like a case where you'd want to use a GROUP BY statement in the dataflow. In MySQL, it would look something like this: SELECT YEAR(`Date`) AS `Year` , WEEKOFYEAR(`Date`) AS `Week Number` , SUM(`Sales`) AS `Total Sales` FROM TABLE_NAME GROUP BY `Year` , `Week Number` I included the Year as a field because if you…

There is not currently a chart property to adjust the weight of lines on a card. Can I suggest that you add this idea to the Ideas Exchange? The product team pays close attention to these suggestions and use them to help decide what features to add to future releases.

Normally this error will happen if you've forgotten to add an Output Dataset to your ETL process. All the transformations may work perfectly, but if there isn't an Output Dataset, they'll have no where to go once they've been processed. Is there a chance this is what's happening in your case? The last step in the process…

I'd recommend using the DATE_SUB() function. To subtract 6 hours you could use: DATE_FORMAT(DATE_SUB(`created_time`, INTERVAL 6 HOUR), '%l %p') You can replace "6 HOUR" with any number and unit you need (e.g. 1 DAY, 2 MONTH, etc.) Let me know if that helps!

You've described the capabilities and limits clearly. The card builder does not include functionality to customize the headers in a table card, nor will cell customizations carry through to an export of the data. Can I suggest that you add posts for these ideas in the Ideas Exchange? Our product team watches these ideas…

Yes is it possible! If you choose "Move/Copy" from the card options menu on a card, you can add the card to a different page. The two cards will remain synchronized, but visible in two different places. Let me know if that helps!

That's a great idea. There isn't a card that displays a website, but you can set up a table card to display a link to a website. You can put a subset of HTML commands into a cell value in a table card and it will be rendered and displayed. If you use the <a> tag you can add a link. Can you add your idea to the Idea…

You can see the available macros by clicking into the "Text" field in the "Data Label Settings" options. Also, you can get explanations of the macros in the Help Center under the topic "How do I format data label and hover text?" Here's the text as it currently reads: Macro Description %_CATEGORY_NAME The name of the…

Currently, there are not options at the card level to create the type of configuration you are looking for. On a table card, each record is used once, bucketed into a particular group based on the categories that have been selected. It appears that to get the type of output you're looking for, the dataset would need to…