AS Coach

I've wondered the same and haven't really found examples, only documentation. That said, this is the documentation for the SDK : http://app.domo.com/workbench/sdk/html/index.html. This is the documentation for the process : https://developer.domo.com/docs/workbench-add-ons/workbench-addons.

No one card jumps out at me right now as automatically calculating that ratio, but most of the cards can use custom calculations to get you there. Say you have a call center and, on average, a person might make 200 calls in a day and convert on 5 of them. Depending on the structure of your data, that ratio would look like:…

Good comment! You know, I've never seen this and I don't think it's currently possible, but you can add it as a new post in the ideas exchange for others to upvote. I can see how it would be beneficial to industries, like finance, who use fractions all the time.

Hi! Funnelwise isn't in the list of connectors, so I'm doubtful it's used much with Domo. If anyone is using it and Domo together, they're getting data into Domo through another path like scheduled exports.

Hi! Some connectors are given out by support only through the link they provide or by permanently adding an otherwise hidden connector. Anything "Advanced" is probably in that group. Did support provide one of those links to you?

Mason's correct, comparing aggregations to individual values doesn't usually work. I've see aggregations in case statements work, but only isolated incidents and never comparing against row values. Just a shot in the dark here, but can you try aggregating each side of your comparisons in your logic, so everything is an…

I don't think you can with Sumo tables. You can bold or italicize columns on regular table cards, though. And be on the lookout for new table card formatting coming out soon.

Same. I've never seen that done (which isn't to say it can't be done) outside of table cards. However, we have been able to insert line breaks in single value cards, so some kind of manipulation can be done there. For example: CONCAT( sum(`value`) , ' Total Sales' , '<br>' ,count(`customerID`) , ' Customers')

Thanks. I'd still rather use the alias, but at least that has remained in some form.

UPDATE: It appears Domo has made some changes to this feature, having automated the popup for reserved words and table names. But I seem to have lost the ability to pull column names. @DaniBoy would it be possible to get an official, current feature spec list from the PM over dataflow?

Yes, that icon indicates a dataflow, symbolizing multiple datasets merging into one.

Is your data straight out of salesforce (you'll know because the dataset icon is the SFDC icon), or is it from a dataflow? If your data is coming direct from the source, then you'll probably just have to become more acquainted with that. If your data is from a dataflow, Domo's coming out with a new data lineage feature…

You're in the table card, so the way you effectively GROUP BY is by selecting your aggregation level on the measure column. Every other dimension column is assumed to be part of the GROUP BY clause and your measure will be summed, counted, maxed, or whatever. You'll just have to take out of the visualization any column you…

Are you referring to cells in a table visualization? Domo has two types of tables and both can be highlighted in different ways * Sumo tables - Like a pivot chart. Cells can be conditionally highlighted (above or threshhold or eqal to a certain value, for example) * Table cards - A simple data grid. Cells can be…

@pravaliya I haven't tried that before, but I would think so. But only up to a certain point. Time data types have a limit. TIMEDIFF() will get you the HHH:MM:SS, like 179 hours, 22 min, 0 sec. So theoretically I think it would calculate that out as (179:22:00 * 3600 s) / 60 s = 10762 minutes . What are you getting?

That's where the sort comes into play. If you include the beast mode as a sort in addition to it being the "Pie Name" value, it will force the labels to be sorted. They you can assign color to the series values, which will always be sorted the same way: Alphabetically Series 1: Green Series 2: Red Series 3: Yellow

The date_add function takes parameters of a date column and a time interval. It's great because the same function can take intervals of days, weeks, months, or years. This can be especially helpful when dealing with months since months aren't all the same length. The function is programmed to deal with that. Take, for…

For that I'd probably do this: CASE when curdate() < date_add(`custtransdate`, interval 3 month) then 'green' when curdate() >= date_add(`custtransdate`, interval 3 month) and curdate() < date_add(`custtransdate`, interval 10 month) then 'yellow' when curdate() >= date_add(`custtransdate`, interval 10 month) then 'red' END…

The reason your beast mode is always green is because a date is always less than a date + 90, so I suspect the date logic needs an update. Are you trying to compare the current date to the custtransdate, maybe? CASE -- for dates within 90 days ago from today when curdate() <= date_add(`custtransdate`, interval 90 day) then…

At present you can't filter on aggregations, but Domo's aware of that need and are working on it. There might be a way to use beast modes though. A conditional in a case statement like this: CASE WHEN sum(`value`) > 10000 THEN 'Yes' ELSE 'No' END Use a filter like that, select just the 'Yes' values. If it works depends on…

Domo doesn't have a native "copy and update one thing" type of function, but they've developed some internal card duplicating tools that might do some of what you want, which they might help you leverage. Get in touch with your customer success manager and see if they will discuss some of those options.

I think you might be right. I seem to remember a setting like "Show only one label" when using the category total macro. If nobody else has an answer I recommend inquiring with support.

In Redshift there is a function called TRUNC that strips the timestamp: http://docs.aws.amazon.com/redshift/latest/dg/r_TRUNC_date.html

There are several Twitter connectors already available in the connector library but none available for Pepperjam. So maybe somebody else has built that one, but are you not finding what you want for Twitter?

The chart you're looking for is "Line + Grouped Bar" in the "Vertical Bar" charts menu. You would have 3 values. One for your units line in the Y Axis spot, one for your % bar (standard) in the first Series spot, and a third for your % bar (express) in the second Series spot. Your % bar series values might have to be beast…

You can reach out to Domo support a few ways in Buzz. You can just @ mention them in a card and ask a certain question, like you would any Domo user. Turnaround seems to be slowest this way. Days maybe. You can open a chat with just you and them and do the same thing. You can create a support ticket automatically by typing…

You're welcome! If your success requirements include that your solution must closely mimic pivot tables, that's not really Domo's intended purpose or main use case. There are likely many ways to visualize your KPIs, though. In my past life I implemented dozens of new Domo clients. The most successful were always those who…

The TIMEDIFF() function will get you the hh:mm:ss value between the two, and the TIME_TO_SEC() function will give you the number of seconds in time. Nest those two and divide by 60 seconds to get minutes. See if something like this will work: TIME_TO_SEC(TIMEDIFF(`EndTime`,`StartTime`)) / 60

You're right, Sumo is limited in a strict comparison to pivot tables. As far as aggregations go, you can sum, average, count, count unique, min, and max. Those are the default options, which you can find by clicking on the Value header in the table. You can use custom beast mode calculations, like dividing two columns, but…

Pivot table-based datasets can be difficult to ingest and work with in Domo. It's best to upload the raw data. As far as building pivot-like reports goes, have you looked at Sumo cards yet? That's the closest thing you'll find to a pivot chart in Domo. You'll start building one from the "Add card > Design" menu.