dthierjung Contributor

Well HTML syntax is very particular, so if it's wrong in the slightest way, say: "<span style="#fff">Sample Text</span>" vs. "<span style="#fff">Sample Text<span>" Bottom one is missing the ending backslash, the HTML is considered invalid and won't render as expected. I can't see the bottom of the snippet you provided but…

The custom html strings should be working still, however if the string is incorrectly formatted in any way it will break and not display as expected. Also, it will only display the proper html in a table card chart view, and not the alternative table view. Referencing the attached image, only the left hand "chart" view…

Domo has a sweet program where you can get Okta for free (so long as that is just for using with Domo as the free app). Check out this link to it: https://www.okta.com/free/domo/ Should be able to handle many various setups, and is pretty robust in it's offerings.

Certainly an interesting use-case, and a smart way to add some user interactivity to Domo. Depending on how you developed your app (Adobe Illustrator or plain HTML/CSS/JS), you can leverage Domo's APIs to push data to a dataset, or push directly to a sql server, for instance. Here's a link that might be able to…

You should be able to accomplish all of this using Beast Mode formulas. You can put the formula you provided above into a beast mode, replacing the appropriate logic and dataset columns as appropriate. You'll probably need to use a few of the available datetime functions to calculate the number of days passed, and total…

This is where a "case statement" within a beast mode will solve your problem. For example, create a new beast mode calculation, and you would do something like the following: CASE WHEN `region` = 'some value' OR `child region` = 'other value' THEN 1 ELSE 0 END Then you can add this beast mode as a filter, and filter it for…

Beyond going into the dataflow history and clicking on the status of a particular run, such as "Successful" which shows you the time associated with each statement, there's no great way to debug the dataflows. At least not that I've been able to find. In each transform, you can get some additional SQL details (see…

In response to item 1), this might just be up to your preference, as I'm not aware of any performance gain by splitting out transforms. Separate transforms would make it easier to debug if necessary. For item 2), as far as I know, dataflows still have to load the entirety of each input dataset so I don't think appending vs…

So in order to see more than 3 columns on a table card, you'll need to change the card size to Full (see attachment 1), and then in the card proprties, change the Full Size Settings to be Card Width: 6, and whatever Card Height is appropriate for you.

Could you provide a screenshot of your card? We might be able to spot something from that. In the interim, I would ensure that the x-axis value that you are wanting to sort on is in the first field of the "Sorting" section, between the "Chart Properties" and the "Filters". I just tested this on a scatter and it appears to…

I believe your issue is the HTML you are injecting. A <div> element will cause a "line break" to occur (not truly a line break but it comes down to the CSS styling that makes it appear as such). There are many different ways to resolve this. If you are familiar with CSS, you can add some inline styling like…

There's 2 ways you could go about this - one using the "Subtotal Rows" chart properties of the table card, and another aggregating your data in a dataflow for your cards to consume. The former option will be visually different than what you proposed above in that there would be a subtotal row in your table, and not a…

Unfortunately there's no setting in the chart properties to do this on this particular visualization. However you do control what field goes in the "label" column, and you get insert some creativity there through Beast Modes calculations and string concatenation. However that will be followed by a colon and the value…

Hm, well if there are differences between the two functions only at certain times of the day, like starting later in the afternoon, then I would say that it is a time zone issue, otherwise I would open a ticket with DomoSupport since that shouldn't be happening.

Unfortunately Domo does not have an option that allows you to display the legend inside the donut chart at this time. If you're feeling creative, you can create your own donut visualization using the developer tools which can be done via Adobe Illustrator or using a more developer centric approach:…

This issue MAY have to do with your company's time zone settings that admins can set. I know that beast mode functions are affected by this. Check out this link for more info, it might provide a possible solution: https://knowledge.domo.com/?cid=timezoneissues Specifically, potentially using the MySQL function…

To my knowledge, there isn't a cap, however I've never gone beyond 5 inputs. I'm not familiar with your data landscape but taking a step back, it might be prudent to consider other ETL options given your estimation of inputs. That dataflow would be cumbersome at best to manage and make changes to, not to mention debug for…

There's a few ways you could accomplish this, and in the ways you mentioned. Be cognizant of time zone that can effect datetimes as well as functions available in beast modes to retrieve a time. The below will work well for a card using a table visualization: Card level filter that filters on the date column, checking…

We were able to leverage the domoR package as well as the Python to retrieve Domo data and save to a MSSQL database, just depends on your preference. Fairly certain they all hit the same API endpoints. Using Python, we used pypyodbc to create a database connection, and then execute an insert statement into the appropriate…

It is indeed occurring because there is more than one user logged in at one time, and I've always been under the impression that the updates it's referring to is the workbench software update that you can set to install automatically. We have our production workbench set up on a central server like many others, and wanted…

Depending on how tech-savvy you are, you can leverage the Domo APIs or DomoR to query datasets from Domo and then push into a variety of other sources such as a csv file, sql database, etc. Those might be the best options in terms of automation. Power BI would then be able to connect to that file or SQL database.

It looks like an answer has been accepted for this issue here: https://dojo.domo.com/t5/Domo-Developer/Location-is-undefined-error/td-p/13222 Based on those comments, I'd suggest trying to run in git bash or windows powershell.

Thank you for the follow-up, I'll post over there instead. I guess my idea is similar to sharing on a dataset, but it would also be visibile when exporting a dataset to Excel, for instance, or usable as a field within an ETL.

Thank you @guitarhero23, that is an agreeable solution.