AS Coach

This just came up here today and I do it exactly like @Godiepi. I suggest posting this improvement to the ideas exchange.

The chart properties category scale (x) menu includes the option to allow label rotation, but it only does so if needed. Most often I find the chart will fix itself before this becomes needed by simplifying the label values, mostly where dates are concerned (eg, displaying only date instead of month-date, or…

Are you asking if this is available or requesting this to become a feature? Scatter plots can use a single category as a series value like product lines or continents. But the function to add an additional level of detail to the bubbles does not exist, like product and its stock level (in addition to the existing x, y, and…

Maybe try a beast mode that categorizes days of week by weekday or weekend, then use that beast mode in a filter and exclude weekends. I don't know if the Domo card builder is going to try and outsmart the x-axis when it's a date datatype by adding calendar days that aren't actually in the dataset.

Yes, I believe so. "Created At" is the date. It goes on the x axis, count of ID wuld be on the Y. There's actually a great Twitter app in the appstore that you can download and get a bunch of content really quickly, with cards already built. You just have to plug in the credentials, pretty much.

Make a vertical bar chart with a goal of 3, counting tweet IDs by day. Or, use a calendar card and use the heatmap colors as your guide.

Have you tried using Sumo card tables? Sorting and filtering works on that card type.

You can do that in beastmode or on, for example, a table card; why Magic? That sort of aggregation work is frequently done on the card level, unless it's a step in a longer process.

For some reason @kwhite2910's original post isn't showing up in the thread but my response to that post shows as the original message. @DaniBoy, something to look at. I don't think that original post had any text in it, just a subject line.

Table cards can be sorted and filtered on the card builder page, like any other card type: Are you referring to filtering and sorting not on the card builder page but on the view page instead? There is a way to do that if that's what you're looking for. For sorting, on the card view page, click on the table view instead of…

If all you want to do is join datasets together but not perform other operations like column manipulation or filtering, Data Fusion is the way to go and is very fast. You can join datasets together in Magic ETL also but there are many additional transforms you can perform. It is much more powerful but also unnecessary for…

This is a great idea and has been suggested in different forms on a few threads on the Ideas Exchange part of Dojo: https://dojo.domo.com/t5/Ideas-Exchange/Aggregate-Beast-Mode-Filter/idi-p/14924 https://dojo.domo.com/t5/Ideas-Exchange/Please-allow-for-use-of-beastmode-calculation-on-the-page/idi-p/10554…

Oh yeah, that's a different story. Two dozen columns would be a nightmare with what I suggested. The SQL function GREATEST() would probably work well in this case but BeastMode doesn't have that function that I'm aware. What's your use case, just finding a max value from an entire dataset? (try using a SQL dataflow with…

Like this: Compared to this:

The only additional thing I can think of is to make sure the numerical column is actually summed, not just displayed, and that the other custom dimension(s) isn't causing the detail to split out also.

I think you have to remove the date column. The aggregation occurrs across the lowest level of detail. Without the date column, the lowest level of detail is custom dimension 22 x custom dimension 26 in this view.

I'd suggest doing something like max(max(x1),max(x2),max(x3)), but I don't think beastmode max functions will allow that. Can you do a case statement with boolean? case when max(x1) >= max(x2) and max(x1) >= max(x3) then max(x1) when max(x2) >= max(x1) and max(x2) >= max(x3) then max(x2) when max(x3) >= max(x1) and max(x3)…

I have not heard of a forum or similar listing of developed plugins. Domo's workbench squad would probably have a good idea about what they've developed and seen others develop. It may just be tribal knowledge at this point. See https://knowledge.domo.com/?cid=wb4plugins for a tiny bit more info.

You're welcome!

@zcameron correct me if I'm wrong, but aggregate functions like MIN() will also be influenced by the chart type chosen and if there are series groupings within that chart. Each stack segment in a stacked bar chart, for example, could have a unique MIN() value or MAX() date value (transactions by division maybe). A MAX() in…

For what it's worth, Workbench can interface with custom written plugins that can potentially do what you're looking for. You'd need someone to script a plugin. Domo also has a "big data" development team that can either advise you or work on this kind of activity for a fee. So you have some options at your disposal.

Inquire with DomoSupport to see about using other versions of DropBox connectors that will give you the file connectivity you want. There is an excellent Box.com connector which allows you to load specific files on a schedule. There may be a good one for DropBox as well. There are some in development, anyway.

For everyone's future reference, Domo has a capability where you can upload data via email attachments, preferably CSV. Domo creates a specific email address for a dataset and those attachments will be uploaded to a dataset in Domo. In this manner, you can get data into Domo via email instead of API connector or workbench.…

Pages, subpages, and collections can't be moved in their entirety. You have to move individual cards. It can be laborious. So your ideas are great. Make sure you put them on the Ideas Exchange page in Dojo. In fact, there may be a similar idea out there already. You can search there and upvote any existing posts.

@rwits by 'slide shows' do you mean you tried publishing cards to the web via URL? That's probably your best option currently. The data would still be living, as opposed to a PPT export, and non-Domo users only need to have a URL to view content, not a license. They do lose interactivity, but they get live data without an…

The paperclip icon is on the bottom left of the Buzz window, directly next to the "Write something..." text where you type a Buzz message. I think it's available to all users, but if you don't see it there you may consider investigating that further.

If you have a channel or private chat open with that person/persons, you can do one of two things: * Just copy/paste the URL from the card. Buzz will turn it into a link, but there will be no preview in the buzz window * Click on the paperclip icon and choose the card option. Search for the card by name and select it. It…

Domo cards can't natively combine two datasets into one card. One option would be to create a Magic dataflow to create a combined dataset with both measures: * sum up hours worked per day on the one dataset * sum up revenue per day on the other dataset * join the two aggregations together on the date column day If you have…

OK, so your third sort category is summed and sorted by des/asc? Theoretically that should work if it's both aggregated and a sort direction is applied. If it still doesn't work you could try putting both the second and third sort categories concatenated into the single beast mode so it's just one long string to sort by…

Sorts should keep working after the first element. One thing you might want to look at is the aggregation level on each sort. Your first and last look aggregated but the second is not. Throw an average function around your beast mode and see what happens.