Starlord Domo Employee

Hi everyone, I am a Tier II Technical Advisor on the Domo Support team, and I actually field this question about Redshift a lot. What you observe about the behavior with ORDER BY in Redshift is actually expected: When Redshift processes a query that contains an ORDER BY clause, it does honor the specified order while…

Hello @user095063, I work in Domo Support, and can provide some help here. Very often, with this type of issue, it'll turn out that something weird is happening with whitespace. Examples I run into a lot are: * Spaces in values are actually double-spaces or tabs (this can be hard to find because most web browsers…

Hello! Thank you for your questions! You are correct that calculations are typically row-by-row or aggregated rows, and don't allow explicit access to data from other specified rows. One exception is Window functions, which currently have very limited Support in the context of Beast Modes. You can learn more about those…

Hello! I assume you mean that, for the alternating row colors that default to white and light gray, you would like to choose a different color scheme. At this time there is no option aside from turning these alternating colors on or off (see the "General" tab of the chart properties). I think this is a great idea, though!…

@Asydnor Have you reported these behaviors in tickets to Domo Support? I would very much like to have examples of these issues you see brought to our attention. If you have open tickets, please reference them here for me. You should have been provided a CASE ID for each ticket opened. If you do not have open tickets,…

Hello! A few thoughts: * Make sure you are using the "PostgreSQL SSH" connector, not the normal "PostgreSQL" connector. * In whitelisting IP Addresses, see this document: https://knowledge.domo.com?cid=connectorips * NOTE that there is one extra IP that should be whitelisted when using SSH connectors, make sure you have…

Hello user08600, please see my previous response. Two apostrophes in a row represents an escaped apostrophe. For example, 'O''Sullivan' is valid for specifying the name O'Sullivan with an escape on the apostrophe.

Hello! Unfortunately, the Quickbooks Online API that our Connector utilizes does not allow for Custom Reports to be retrieved. For this reason, the Domo Connector cannot retrieve custom reports from Quickbooks. My source for this information came from an answer given by a Quickbooks developer that can be found…

Hello! At this time, it is not possible to export a Sumo card directly into pivot view. The data exported is the same data shown in the pivot view, with filters applied, it just is not pivoted. I do not know if this functionality is already on the Sumo Card roadmap, but you can communicate your desire for it to our product…

Hello user009860! This is not currently possible to create directly. To create a dataset that shows this information, you would need to essentially re-create the logic (filters, groupings, aggregations, etc) of each card in a dataflow, so that you have data tables that match each card's data, then count the rows of each…

Hello user09847! What you are trying to do is not currently possible to do with a bullet chart, but I think it's a great idea! Essentially, instead of comparing column values against static values for color rules, you want to be able to compare column values against the values of other columns. I suggest you submit this…

Hello user07750! I think the solution you're looking for is the "Grouped and Stacked Bar Graph" chart type. See the documentation on this chart type here: http://knowledge.domo.com?cid=groupedstacked It allows you to have one bar with stacked values, and another bar with just one value, like you described. Another option…

Hello @user02834, It is now very easy to duplicate pages, but requires Admin privileges. To do so, follow these steps, or ask an Admin from your instance to do so: 1) Create a new blank page with the title you want the new page to have 2) Navigate to the Admin Settings > Cards page 3) To the right of the "Pages" heading,…

Hello osmararv, I am not aware of this idea already being posted in the Ideas Exchange. Please feel free to add it if you would like, so that others can vote on it as well. Thanks! Steve Cook Domo Technical Support

Hello osmararv, Cards are designed to display data that exists in the dataset they are built on (after filters are applied). If values do not exist in that data, they cannot be included on the card. The only current exception to this is the Time Scale that creates a scale for date and datetime values. Requests have been…

Hello mep321, Create 2 Beast Modes: * MIN(`Date_Of_Service`) * MAX(`Date_Of_Service`) Name each Beast Mode how you would like to see that value labeled on the card, then place the Beast Modes into the card in place of your current MIN and MAX columns. Beast Modes are treated as separate columns, so you will not experience…

Unfortunately, Domo Support can no longer fulfill requests to duplicate multiple cards at once, but there is a feature on our product roadmap to include that functionality within the Domo UI in a future release. Due to the complexity of implementation for this feature, an ETA is not available. Once the feature is…

Hello @Shevy, As a reminder, I contacted you via email asking for a link to your dataflow so that I may help troubleshoot this issue for you. When you're ready to proceed, please reply to my email, and I can help you then. Thank you! Steve Cook Domo Support

Hello bradsafeguard, My name is Steve Cook, I work in Domo Support, and I want to help you find an answer to this question. Please check your email for a message I have sent you there. Thanks!

To escape a single-quote in a Beast Mode equals "=" operation, use 2 single quotes instead of 1. For example: CASE WHEN `lastName` = 'O''Sullivan' THEN ...

Hi Candice, Does your company use Publication Groups? If not, "editor" users only have access to view data from datasets which have been shared with them by another user with access to that data. A dataset is shared with a user when any card built on that dataset is shared with them. There is no more direct method of…