AS Coach

There isn't an interface where you can simply take a data set and delete rows. However, like you mentioned you can use SQL Dataflows to write a statement to filter out the rows you don't want, then create a secondary data set as the output. Once you have that, then you might not need your original data set and can delete…

This is currently in beta as part of the admin page, so we're almost there.

Referring to data types, categories are text or date fields and values are numbers. You can turn a number into text by using a CONCAT() function in a Beast Mode. Something along these lines: CONCAT(`Organization_ID`,'') Add blank text to the end of a number and the output will be that number as a string of text instead of…

Just a guess here but it sounds like they don't have permission to see the dataset. I'm surprised adding a PDP policy didn't resolve that. Run a test by creating a generic card for dataset2 and share that card with one of your people. Have that person then try to drill in the original card to the drill path into dataset2.…

The option that jumps to mind is the chart settings for 'balance distribution': By default Domo takes the max and min values, divides the range into 5 or so equal amounts, and then labels the countries as they fall into each of those buckets. Hence the US at the top and everything else at the bottom. By using the balanced…

You've stumbled on one of the quirks of dataset names. When you add an input to a dataflow, behind the scenes Domo is creating a JSON object and the original name (the name of the dataset at the time you added it as an input) is stored in the name/value pairs. Whenever the dataflow references the input it looks for the…

You can keep the regular date field on the X Axis but on the date picker choose to graph by week, instead of choosing the week number directly on the X Axis: Then it will roll up to the week level. At this point Domo gives two options for how to display the weekly labels on the axis. You can see them by week number like…

Looks like it's still set up to show daily, then you've just filtered out the values on the other days. Does the same thing happen if you graph by week?

Domo used to actually not display lone datapoints at all and only showed connected lines. So, there's that. Sounds like you're asking for Domo to go one step further and connect the points, regardless of missing spots. Example: March at 10 and June at 15, with a straight line between the March and June, even though April…

Thanks and you're welcome. Same to you.

Hi Bill We have many table cards that do something similar (Ship Day is roughly equivalent to business days): In order to do this we have to bring in a dataset in our dataflow which has a calendar of what days count as business days. Then we can flag the transaction day as a business day or not. We have another column that…

I have only seen it work successfully when you do almost all of the filtering in dataflows before AI gets ahold of the data. Last time I tried I could let the card do simple operations like sums, but I had to do a bit of dataflow work to prepare the data. You may have to experiment until you find a method that works for…

There's a Traffic Metrics report you can pull using the GA connector. See this article: http://knowledge.domo.com?cid=googleanalytics Domo also has an excellent advanced GA connector that allows you to create custom reports of your own. This is the connector I've always used since it's so powerful, though it does require…

The existing search feature looks at card names and other things like user names, but does not look at dataset schemas. If you update a dataset and it changes a column name that's being used in a card, that card will display an error. So you'll be able to see on the page view which cards are broken and can fix them…

That's a fair amount of data and it's good that you ask for help. In the first case, if you're just appending the last 6 hours worth of rows (6/24 * 4m = 1m rows), Domo should be able to handle that, depending on the transport method. Workbench can handle that. Some of the APIs might hit their limit if you're usign a cloud…

It's possible this feature hasn't hit the environment you're in, but we have it now (the ability to slide the pane width). Ask Support, your consultant, or other Domo contact.

I had a similar error and mine seemed to be caused by the nulls in my data (I experimented with samples of my data until the error went away). I sent my error to Support and am awaiting resolution.

Hi Martin In the Data Center on the DataFlows option, click on the New button in the top right. In the Magic Transform section, depending on what features are "turned on" for you, you'll see the options Blend, ETL, SQL, and R. If you see SQL and click on it, a new window may pop up that allows you to select MySQL or…

No, I think the card isn't behaving the way it should but you might be able to get around the issue by tinkering with other settings. I observed the same problem on one of my cards but was able to resolve it by using the special formatting but changing the date level from day to month.

Leave that formatting in place, but switch your date aggregation around, to day for example instead of month, and see if that helps. Experiment to see what works.

Best is to ensure the column is set as a number type of some kind on the dataset side. This can be done through MagicETL/Redshift. If it can't be done, do the Beast Mode trick. And if that doesn't work on the preview, try saving the card first and seeing if the full card view will display the card correctly even though it…

You bet. It's extremely useful. Domo could make some good money off selling that app, for sure. 

There's a drill path method you can use where you start with a US State map first, click a state, have a county map as the drill path (which zooms to the state and shows metrics by county), and you can further drill to zip code from there to see zips by county. That's pretty helpful. It doesn't show top-level counties, but…

Can you change the format on the input side to conform to Domo's format? That could be the quickest solution. You could try using ETL or Beast Mode extract the date parts and reconstruct them into a new date column. Something like this: STR_TO_DATE( CONCAT( YEAR(`Date`) , '-' ,DAY(`Date`) , '-' ,MONTH(`Date`) ) ,'%Y-%m-%d'…

Sometimes in my beast modes I've been able to multiply text, that should be a number, by 1. Then I use that beast mode in my cards. For example, '3'*1 usually resolves as 3*1 to get 3.

@ecenteno I haven't been able to color my null cells. Not that it's impossible, but I haven't found a way.

I don't know if this is in the backlog (you could suggest it in the Ideas Exchange here in the Dojo), but it is possible to build a custom card using the DevStudio. You can make just about anything with that, though it requires web development experience.

Domo uses a map this for their internal employees and it's amazing. It has office and cubicle blue prints by floor, by campus building, with searchable info for employees and their location numbers, and linkable to their Domo profiles. Regular conference rooms are on the map also, I believe. It's an interactive custom app…

@DaniBoy, this is what I see when I click on your link and I notice the URL says it's a beta feature: Thre is also this article in the knowledge base, which goes over the SQL version: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Period_over_Period

That may not be an article everyone has access to, @DaniBoy. But I wouldn't be surprised if some kind of PoP approach is documented somewhere.