AS Coach

You might check out this thread. It's a few years old but I think it still applies today. I don't think there's an easy solution right now. Because there isn't we typically just round our numbers to the nearest thousand or million, depending on the size of the business and the audience.

That's a .NET server connection issue. Is your workbench version correctly connected to your Domo instance (with a current API key and Domo server) and also to the data, whether it be ODBC or file? Does that happen when you preview the data or only when you try to run a job? It sounds to me like one of those sides is…

Hi Andreas This isn't by chance a CSV that was saved from Excel, was it? I had a similar problem a couple years ago and if I recall correctly, there was an issue with the scientific notation (ex 4.3Ewhatever) that Excel was using. I actually don't recall what the solution was, unfortunately, but maybe that gives you a…

So you want to show volume, but not necessarily tied down to a specific time, since that line can jump from nothing to something and back down again, appearing choppy maybe? What it your time units were wider? Like every hour instead of minute, or day instead of week? Or even varying amounts, like 12AM-6AM, 6AM-9AM,…

There is a DomoMetrics type dataset called Users by Role which contains the person, their permission, and a row of that person for every group they belong to. You might need to get in touch with support to get that spun up for you. Columns: User : Person's name from their profile User ID : Domo user id Employee Number :…

You're welcome. You know, I'm not sure about your first question. We don't have external users with our publication groups, but it very well could be what you're wondering. I suggest trying it out with a demo user on a single extra page and seeing what happens. About different cards on different pages, you're really…

That's a really great question and I'm interested to see what the community can come up with for you. Here's a thought I had. Set up one page with full access, and set up six publication groups, one for each program. Each access group will be customized to each program. One page controls everything, but essentially six…

We recently had the same issue. Our department head (privileged user) couldn't see the drill list for some cards on his pages in order to edit the drill paths. Support's response: Currently only Admin users can edit drill views created by other users. This is built into the different levels of permissions. It doesn't help…

Hi Bikash I can't think of a way to nest multiple time labels on an X Axis. Here's one thing you can try, though. Create a Quarter beast mode and use it as the series in order to call attention to the quarters in addition to the weeks on the label

It took me a bit to get my XML jobs coming in correctly. It might be the Flattening Options setting, found on the Source menu. I have mine set to 'Deep' instead of 'None' or 'Wide' Does that help?

Unfortunatley, Domo removes the option to manually update a column name once the datafusion/blend has been created. Check out this thread: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Data-Fusion-Request-Changing-Column-Names/m-p/30870#M4464 I don't know if this person ever created an Ideas Exchange topic, so you might…

Can you give us an example of a situation for your particular vlookup needs? The answer might be different depending on what you are looking for. It might be a dataflow that you would need to use, it might be a case statement in a beast mode, or something else entirely.

How do partial months and rounding come in to play for your business? Is Jan 1 - Feb 28 two months? What about Jan 15 - Feb 14? One month or two? What about Jan 31 - Mar 1? One month or three?

There's a beast mode that can do this. DATEDIFF Returns the number of days between two dates from datetime values. DATEDIFF(CURRENT_DATE(), 'lastmoddate') Is that what you're looking for?

YEAR() expects a datetime value. Just try year(`Close Date`)=2017 and see how that goes

Domo stores a bunch of metadata about each dataflow run. How long it takes to load each dataset (ms) How long it takes to run each transformation How long it takes to load the output to permanent storage How many rows are loaded Timestamps at each step How many rows are written Etc. I did some more research on the similar…

That's frustrating. And running dataflows don't show that detail. One of my dataflows just now had the same problem and I can't tell either. Usually it runs in a few minutes, but this one autocancelled at 45 minutes This almost sounds like a processing engine problem. Like a system hiccup, especially if those dataflows are…

It sounds like an action in your ETL is just getting hung up, after which the process resets. Have you viewed the dataflow history tab that shows what happened at each step? This screen is helpful to view where breakdowns happen and why. On the last column, status, the green or red Success or Failed icon is a link. If you…

Does your card have any granularity, like a table card with a dimension with lots of variety, where at least one of those combinations might have a divide by zero error? Like a new salesrep who doesn't have any sales yet and might not have the data used in the denominator. I fixed a card like this for us yesterday with…

Hi @Greg_B That particular card doesn't have ranges like a radial gauge. Have you tried using the radial gauge with a percentage measure? We use those for sales percent to goal KPIs, for example. You might also try using the comparative fill gauge cards. The advanced version of that card has quite a number of features (it…

I set up a SQL dataflow to help us report on customer churn. Domo doesn't have the best tools right now to report on cohort analyses like this, so you kinda have to hack your way into it. What specifically are you both trying to calculate?

When you switch to the new dataset the beast modes belonging to the prior dataset will be left behind. On the flip side, your card-saved beast modes will carry over. That seems in line with what you're finding. By blend are you referring to data fusion? That's not a new dataset but rather a view, so it might be possible…

You'd probably want to look into using a recursive dataflow: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-can-I-add-only-unique-values-from-one-dataset-to-another/td-p/16549 The dataflow feeds into itself and builds up over time. It's a really nice trick to have in your Domo quiver.

I'm sure Domo is aware of this request. It was a problem 3 years ago when I was there. Data Fusion isn't a big priority for them, compared to other product features. I can't say where it is on the roadmap, though. They keep that information really tightly held.

Now that you mention DAYOFWEEK and WEEKDAY together, my previous ticket with Domo was regarding these two functions comparatively. They used to display the same value, even though that beast mode editor function description indicated one was 0 start and the other was 1 start, but they were functionally identical. Sorry for…

Aggregations inside of beast modes are really problematic. There are a few threads out there in Dojo that go into more depth on this topic. To solve it you essentially have to turn the beast modes inside out. Instead of "if it equals X, count it" it goes more like "count it if it equals X". Count of Ducks this year would…

I submitted a similar request probably two years ago when I worked for Domo. I guess it still hasn't been fixed...

That's a nice idea. Make sure to add it to the Ideas Exchange. More generally, colors changing once they meet a condition is something Domo is working on, but could be better. Conditional formatting is part of new table cards, so you could transition card types if you want to take advantage of that. There may be another…

Yes, sorting depends on what you want in your string @Valiant. I've done in the past on other card axes as @ST_-Superman-_ suggests, but it applies equally as well for table cards.

Subtotal rows do automatically sort the first column in the primary position. The data would be hard to read otherwise (jumbled category elements but aggregated, misordered categories?). You'll see a faded column name in the sorting properties frame. You can choose if this is done ascending or descending, though, which…