JacobFolsom Domo Employee

@Joss_C Besides Google Sheets, you have options to automate. Consider putting the data file in a place that can be pulled via any connector. For example, a csv file on a SFTP server can be pulled via the CSV connector on a schedule, or on a common file sharing platform, like Box or DropBox also has connectors to pull the…

I agree this could be a good enhancement to Heatmap tables specifically, as that doesn't show up in their chart properties. My recommendation for an alternative is to use Mega Tables as column names are locked at the top as you scroll. See also Chart properties > Heatmap options in to apply coloring to get colors how you…

@tmerchant this error I would guess is coming from attempting to do the calculation in a Magic ETL formula tile, which does not allow aggregation. It will run in a beastmode on a card as @david_cunningham tested. If you want this to be in a Magic ETL formula, use a Group By tile instead, select the columns groupings and…

Jumping into an old post here to confirm from a customer conversation today that there is now a feature in Checkbox Selectors that allows Select All or None. Once the filter card is on a page, you will see this a the top of the card Once that is checked, you can then 'Select none' to uncheck all

@swilliams PPT exports and Scheduled Reports are designed to be a screenshot rendering of a card and have a limitation of fitting onto a single page, which with long table cards will cut off the table. Couple of thoughts moving forward: When you send/export a card to print to PDF, the table gets larger, but still limits to…

@Pritesh I haven't bumped into that one, but a workaround to consider since you are using scripting tiles in Magic ETL may be to handle the null values prior to the python tile using a formula tile. For example, I have a couple columns in my dataset with a null value and choose to write formulas to set defaults for text or…

@randall_white more specifically to your data, I believe you need a new formula for received/ordered that calcs the running totals by unit ordered by date…something like this: SUM(SUM(received)) OVER (PARTITION BY UnitNumber ORDER BY Date) / SUM(SUM(ordered)) OVER (PARTITION BY UnitNumber ORDER BY Date)

@randall_white there is a feature in Domo tables to display as running total in the ‘Show Values As' menu of a column. I have tested this out in Pivot Tables, and it seems to work vertically, but not horizontally.. For example, my pivot table below will sum up revenue in running total for all rows in September column…but…

@arnabm Unfortunately, this is not currently an option in the UI. My recommendation would be to submit a post to the Ideas Exchange as Product Feedback for others in the community to upvote the idea of having an exported dataset containing the projections. If you haven't posted there before, check this post out…

This will run faster is you utilize indexing in MySQL (help article), which would require a transform for each of your tables to create two new columns for the month extracts you are joining on...e.g. LDGRDATE_Month and LDGRDATE_PriorMonth. Once those columns are created, you can add an index to them prior to joining them…

posted duplicate to new internal dojo board https://dojo.domo.com/internal/discussion/55255/how-can-i-use-the-match-function-with-a-declared-variable-string-in-a-mysql-dataflow#latest

The solution here requires using the SQL transform instead of the Table transform option in MySQL flows with a few steps below. Disclaimer: I would probably solve this in other ways, but to answer the specific question gives some detail on how stored procedures work in MySQL flows. Step 1: Write a SQL Transform to add a…

@JustinB , case when impressions < 20 then 1 when impressions < 40 then 2 when impressions < 60 then 3 when impressions < 90 then 4 else 5 end If you need to use SUM(Impressions) then it will no longer allow you to average. So that impressions number would need to be rolled up to the granularity needed for the scoring…

I might recommend using a Pivot table with the Hierarchy for Campaign and Ad set on the Rows and set the Aggregation to Average on your Ad Score beastmode. When you collapse at the Campaign level, this summary becomes more clear

Here is a working example of applying custom background and font color to a table cell. In this case, if sales amount total is <300K then it's red background with white font, otherwise green background with white font. CASE WHEN SUM(`Sales Amount`) < 300000 THEN concat('<div style="background-color:red; color:white;…

@Gulam , check out this on Ideas/Exchange https://dojo.domo.com/t5/Ideas-Exchange/Allow-for-user-entered-parameter-which-ban-be-used-in-beastmode/idi-p/32652

@PantoViz I would love this as well. Domo Product Team - Adding my ideas here to configure filters with 'scope' settings: * Apply to card, apply to entire page, apply to page + subpages. Also, would love to see filter configuration settings for 'priority' * (1) ignore card filters or (2) observe card filters. This would…

OVER() indicates the function is not a plain aggregation, but an analytic function. It's also called a window function because you can specify a window of rows to evaluate. In the example above, OVER() is empty which indicates that the SUM is to be across all-time and all groupings, thus returning the grand total. Here is…

Good call out @Godiepi . I would also recommend looking into bullet graphs as a visual alternative. You can configure data labels for each section. This works well when you need visualize single or multiple categories and plot actuals vs target vs range values. Also, notice the summary number which uses the referenced…

Hello @user11319 , The Cloud Connector for Access is SFTP connections only, so you will use Workbench and connect through the ODBC driver to query the tables stored locally. For more info, Check out this post in Dojo for the solution

Great suggestion. We currently do not have this option. Please submit this to the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas. There are some exisiting requests for radial gauges, mostly around dynamic ranges instead of hard coded labels, as you mentioned with the beastmode…

Hello @Godiepi , This is currently not a documented feature. I recommend you reach out to your Customer Success Manager and they can bring in a member of our Tech Solutions team to have a working session with you to explore best practices and use.

Hi Jay, Color formatting is not currently an option. You can upvote the existing request here https://dojo.domo.com/t5/Ideas-Exchange/add-color-formatting-capability-to-SUMO-Card/idi-p/15651 I should also point out that our Product team is developing a new pivot table functionality that will be a table chart type, with all…

Hello @Justin1 , thank you for your question. There is not an option to delete associated content when deleting a dataflow. I suggest making an enhancement request through ideas exchange. I agree it would make sense to provide the configuration to choose, instead of just indicating that a dataset is affected.

A dynamic solution at card level can be to use a window function. It's not currently documented and may be subject to change, but I've found it to work for basic aggregates: SUM, AVG, MIN, MAX In your case, you could get the grand total: SUM(SUM(value)) OVER () And for % Total: SUM(value) / SUM(SUM(value)) OVER ()

The code below will produce negative fractional hours if Start Date > End Date and positive fractional hours if End Date > Start Date. (UNIX_TIMESTAMP(`End Date`) - UNIX_TIMESTAMP(`Start Date`)) / 3600 NOTE: UNIX_TIMESTAMP() returns the number of seconds since 1970 and will therefore only work on dates after that time.

@John-Peddle I can't see anything wrong myself. Is "Current" in your Summary Number set to Last? It may be that the 29.94 is the First.. What happens in the Summary Number if you only have the line for Unscheduled Breaks instead of adding them together...will it show 8?

@user02364, You can accomplish this using a SQL Dataflow with two steps: 1) Summarize the Won/Lost counts as column values at a monthly level by Employee 2) JOIN the Summary data to the Sales data on the Employee and Date. (These steps are combined in the statement below) -- Aggregate all to Monthly Level and Pivot out Won…

@Wenling_Zhen, There are some inherit limitations with each connector, depending on many factors from Vendor API limitations like a date-range limitation or a usage throttling imposed to prevent you from querying too much data from them. It could also be an issue in the Domo connector code that needs to be investigated. I…

@Wenling_Zhen, There are three upload options in Domo: * Workbench * Connector Framework * Dataset API and Stream API Within the connector framework, there are some limited options, such as the standard File Upload connector which is limited to 256MB files from a local file connection. For larger files, you would use the…