-
Getting Buzz message when a form submitted
Hi all, I created a form in an app to get feedbacks from the users, in order to improve the app as they want. As soon as any user fill and submit the form, the data will get autogenerated in a data provider Now I want to get a Buzz message when a form has been submitted, so we are not missing any feedback. But I don't know…
-
Full-Size Card Background Color and Filters Background Color
I have created DOMO dashboards with a color scheme that is in-line with my web application. The embedding of the dashboard is seamless. However, When I expand on a card, the background is the defualt white background. Additionally, when I click on the filter icon in my application, the filters bar is also the default color…
-
How to connect two cards.
Hello, I'm currently working on a Dashboard. In this dashboard I have three different cards: one is a slicer that allows you to select certain deal numbers, the other is a product description based on the deal number, the last one is product description by date. Now what I have not been able to figure out when I select a…
-
Org Hierarchy and Sunburst Chart Limitations
I'm working on a Sunburst Chart to show organizational hierarchy. I'm running into some issues where I've got 3 levels to my hierarchy and I'm only able show 1 of these without the visual disappearing. I've attached the sample data I'm working with and here is the setup on the card: Is this chart just not capable of…
-
Looking for highest volume by a specific day as well as highest volume during a specific week
Hello, I am trying to take the data below and generate which day of the week has the average/max/min on volume. I would also like to know the average/max/min by day of the week and week of the month. How would I go about doing this inside DOMO? Essentially I would like to be able to answer the business question as follows:…
-
Beast Mode: Nested Case Statement Help
Hey, I'm trying to select week id base on the current day and I wrote below case statement. But I'm getting error in here. Can someone help? (CASE WHEN week_id <= ( CASE WHEN CURRENT_DATE() BETWEEN '2024-02-10' AND '2024-02-16' THEN 1 WHEN CURRENT_DATE() BETWEEN '2024-02-17' AND '2024-02-23' THEN 2 WHEN CURRENT_DATE()…
-
Quarterly Snapshots of Data
Hi gang! A two part question where answers that a newbie like me can understand are very much appreciated please :) I need to build some cards consisting of quarterly snapshots of a dataset. The dates aren't fixed, and I would like to have control over when the snapshots are taken. What's the best way to go about this? In…
-
Is there a setting to stop Legend partially hiding?
You can see in area of the card below that I've highlighted, that the top value of this Legend vanishes when I interact with the card. Can I stop this behavior? Thanks
-
Multi Value columns Displaying wrong %
Hi, Am I missing something here? I have this card that compares last month % to this month %. However, It is not adding up correctly and I cant seem to figure out why. The 19% is the correct value for this month. Last month the value was 23%, I am not sure where 14% is coming from. If I switch it to a table view you can…
-
Returning a Max Result in a column
CASE WHEN D's % of AOR = MAX(D's % of AOR) THEN 1 ELSE 0 END Some how this is returning the total for the column. All values are returning a 1.
-
DomoStats dataset - DomoEverywhere subscriber instances
I would like a DomoStats dataset listing all my Domo Everywhere subscriber instances/organizations. We can see the list of instances in the UI but can't export them. We can extrapolate a list of instances from other governance datasets (like activity logs), but this would only capture instances with data in those datasets.…
-
Date Beast mode
Hi everyone, I have a pivot table which contains plan data. The key point is we need to allow one month post plan completion to allow for data collection and input. Country Plan Name Start Date End Date Status Delivered data available Austria Plan 1 1st Jan 2024 1st March 2024 COMPLETED YES Malta Plan 2 1st Jan 2024 1st…
-
Legend includes colour rules
Hi folks, The legend on a link chart is including the rules set for the colours. How can this be removed to just show the label Thanks
-
Default Set Legend to EXCLUDE Colour rules
Referencing this: And this: Example: When you don't want to have to transform all your data just to make the legend work. The root issue here is the limitations of the colour rules.
-
How to share a dashboard with interactions to external clients?
I want to share a specific dashboard with interactions to an external clients. I was able to export the dashboard with summary but not with interactions to select within it. What are the possible ways to achieve that in DOMO?
-
I have an email with two attachments that go to different datasets. How to extract?
I have an email coming in from a vendor that has two different .xlsx files with two different datasets. Each file would end up in separate datasets in Domo. I've already asked if they can combine into one and got the standard "not at this time" answer. What is the best way to handle this so that both files get into their…
-
merging old data set and new data set
I have the old data set from one source that will not be update any more. The new data is coming from a different source. What is the best way, moving forward to merge these data together?
-
Option to Keep or Clear filter selections when navigating between apps on Mobile devices
Our field users are frustrated that their filter selections don't persist on iPad when navigating in and out of the app (to check another system ie email, crm). Their use case is typically creating "on the fly" filter selections based on what they learn on-site at a particular account. They would benefit from an option to…
-
Displaying Zero value fields in charts over time
We have a chart based on data that is updated daily, however it only updates if the value has changed. We want to see the flat line, i.e. if there has been no changed over time. I've tried changed the chart types and even change it to year to date, it displays nothing i.e. no data Any ideas?
-
How to get filter selections to persist on mobile devices?
Our field users are frustrated that their filter selections don't persist on iPad when navigating in and out of the app (to check another system ie email, crm). Outside of creating & saving a preset filter, is there a way to keep filter selections in place until the app is closed? Their use case is typically creating "on…
-
Multiple Values for Data science Chart
Hi, I am wondering if I could also display the low below the low Line in this chart as well. Thank you
-
lookup function in beastmode?
Hi all, I have a table that has these columns: loan number other loan number first principle balance hi type description 2nd mortgage amount is the field we are trying to create The logic is such: when hi type description = '1st mortgage' and other loan number is > 1 then i want to look up the first principle balance of…
-
Add a Header Option in the JSON Writeback Connector
I have a situation where a client wants us to post data from a dataset to their webhook but it needs custom headers so I can supply an API key. The JSON writeback connector doesn't have any custom header configuration options as part of the connector setup. I also explored using the JSON No Code connector to post data, but…
-
Mass Renaming Columns
Is there any way for me to mass rename columns? Instead of going into the "Select Columns" tile and going down the list 1 by 1 can I copy paste a text file somewhere that will do this? In any other case I would be fine renaming, but right now my dataset has an output of almost 700 columns.
-
Embedded Request Form - ClickUp
Hey all! I'm curious if anyone knows if this is possible? I am wanting to provide this request form as an embedded view where someone can fill this out within Domo then it will automatically go through the Click-Up platform we use. As of right now, we just have it as a link that takes you to the request form in a separate…
-
Count of ID when condition is met
Hi guys, I hope you are able to help me with the following situation. Example: Customer ID1 — Customer ID2 — Status — .. ABC — DEF — ACTIVE ABC — GHI — ACTIVE LMN — OPQ — ACTIVE LMN — RST — INACTIVE Basically I have two IDs per customer, I now want to get a COUNT of "active per customer" but ONLY when Status = ACTIVE. My…
-
Can I run a Stored Procedure to an external MS SQL and import resulting dataset?
I have large amounts of data stored in an external MS SQL database. Complicated queries are run via a stored procedure, and the resulting dataset is written to a table that I currently have connected to DOMO to produce client dashboards. I'd like to call the stored procedure from the DOMO data connection, have it run,…
-
Table, compare several month-over-month
This seems to be similar to the thread located here, but a little more extensive as we're looking to create a table that would compare several months as opposed to just two. https://dojo.domo.com/t5/Card-Building/hello-how-to-compare-month-to-month-with-secondary-axis-in-card/m-p/38214#M5099. And it looks as if a table…
-
Access Token Reporting
In trying to research which accounts an access tokens affects, I found that there was no way to do this. In the case of a termed team member we have no idea what might break when we delete their user if they own an access token. My suggestion is to add reporting around Access Tokens, specifically in DomoStats | Accounts.…
-
Drillpass symble
It's currently difficult to tell the difference between a card with a drill path and one without. At our company, we've tried prefixing the titles of drill cards with "/d:", but this method isn't immediately clear. It would be helpful if we could add a specific mark or icon to cards that have a drill path set, making them…