AS Coach

Color mapping isn't currently a feature Domo provides (outside of beast modes using HTML in table cards), but it's something they are working on. See this post on the ideas exchange. Is that what you're basically looking for?

With Redshift I don't think you can reference WITH clause views within themselves, like you might be able to with other databases. Amazon's WITH documentation and list of some unsupported features (where recursive CTEs are listed).

I was just asking my success manager about that feature's availability. Thanks!

I can't tell you why, but I can tell you that we experienced some of the same issues with replacement variables. In some instances we decided to take a different approach by creating multiple replacement datasets of different timeframes and stacking them into one. In other cases we've kept the append, removed the…

If it's installed and PP still isn't showing and you've followed the directions at the help page, then you'd probably want to get on the phone with Support. PP automatically detected the install for me without issue, as was the case when I installed the newest version.

Sounds like a permission thing. Here are the default options: Admin, of course, can do everything. The access level is granted on the People tab of the Admin Settings page, which you might not be able to see.

Good idea. This amounts to a custom map, which aren't available in the default card options of Domo. I've seen a map or two that were created in apps. In those you can set up whatever geographical boundaries you want. It needs to be created, though. If you don't have a developer on staff, you could inquire with Domo…

That's very possible. To test that, create a beast mode that just looks at the first two decimals. Try a ROUND() function.

To get values to group together there would need to be an aggregation of some sort. Either on the SQL or on the table card. For example, you could sum the transaction column but not the amount column to get the number of transactions per transaction amount.

Do you have an aggregation of some kind in your SELECT statement? Like a SUM() or COUNT()?

You certainly could replace all 15 million rows every day, but that would likely be too taxing and is overkill. Unfortunately you can't replace only a section of those 15 million straight on the source, but you can implement a dataflow that can do this for you. There are a couple of articles and posts here that go into…

@lesliefenwick Depending on what kind of data source you're pulling, you can accomplish this a number of ways. If you have a connection to a structured dataset like mySQL, you can just pull that data with a typical SQL query, probably using workbench with your respective ODBC drivers. For example, we have several oracle…

With table cards you can insert HTML in a CONCAT() function to turn a URL into a clickable hyper link. Cards can't automatically open new windows, though. This post talks about how to create links.

You're right. To put it in context, Domo as a company wants to provide enough Domo product customization that clients can be really productive and find something to suit their needs, but not so much customization that they can change to the nth level of detail and make something that, juxtaposed against the greater…

Just keep tinkering with those settings until you get something you like. Go higher on the max, maybe, maybe 14 or 15 or 16. Using the Max Gridlines should help, too. There is less flexibility here compared to Excel, for example, but you can usually get it the way you like. Watch out for future high outliers, though. They…

Yes. The dummy dataset serves only as a trigger. It is an input to the dataflow, but its data is unused. The data comes from the primary dataset only. Dataflows don't care whether the inputs are actually used, so we can take advantage of that "feature".

Hi Craig I've seen people create a dataset solely to trigger dataflows before. They set the workbench update schedule to be the dataflow schedule they want, and then create the dataflow with only that one dataset as the trigger mechanism. That way whatever happens to the other input datasets, it won't reflect in the cards…

Beast modes use SQL-like functions. CONCAT is a concatenate function that puts together various pieces into one longer string. The Beast Mode editor has a pretty good functionality for finding and describing many other available functions, so poke around and see what will be of use to you. In addition to functions you can…

Domo is working on window functions in beast mode, so I think you'll be able to see some of those this year (my guess). I look forward to some of this higher level analytical functionality.

Happy new year, indeed! As far as I know Workbench doesn't work with API endpoints. You'd probably have to create a custom API within Domo. Documentation here.

Austin, generically speaking, would your calculation look like this? (last week of [page analyzer time period] - first week of [page analyzer time period] ) / first week of [page analyzer time period] Beast mode query language allows you to pretty much only dynamically reference current_date, not the dates underlying the…

As you can see in the IG app you downloaded, you can view web-hosted image files by using HTML in beast modes in table cards. That includes the images of actual posts or user avatars. Check out the beast mode logic there. It looks like this; CONCAT('<img src="', 'html link', '">'). Your card could have a column for the…

It would be pretty tought to have all that flexibility with the raw data as-is. You're talking about handling the same rows of data multiple times, treating each run differently depending on where they are in the ratio. Filtering on a customer in this case won't work because it would filter out the rows for the…

Yes. In the General section of Chart Properties you can set "Number of Lines"

The link works differently depending on if you use a preview or full saved link? You might want to reach out to Support for that.

I don't know if this is part of an open beta or not, but you can contact Domo to find out.

Have you looked at publications? You can create an open or private URL that will always have the most up to date card(s) view and it will be accessible via the web.

For what it's worth, we have pages for personas as well as PDP/Publication groups in place. The execs have their page and can see everything. The managers have their page, with slightly different cards, and can only see their own segment. The reps can see the reps page, again with slightly different cards, and can only see…

Sure

A feature is in beta right now that will allow you to 'click and drag' over a section of the card (a trended vertical bar or line chart is a perfect example) to focus on just that part you clicked over. It's like a drill in that you click on the top level of the card, but it keeps the axes and everything else, simply…