-
Disable Scheduled Reports when data is blank
Is it possible to automatically disable a scheduled report when there is no available data on the last update/filtered date?
-
Email Connector: Unable to figure out why my regex not working
Dear DOMO community, I am at a loss and don't understand why in my email connector the regex .*PANAY.* will work when email subject is Fw: MSPANAY GROUP |IBITEM AND AVAIL - 9/8/2023 7:17:56 am but it fails when the email subject is Fw: MSPANAY GROUP | Ibitem, Price Change and Avail - 8/28/2023 7:54:21 AM When checking…
-
Dynamic Quadrant Lines in ScatterPlot
We need dynamic/smart quadrant lines in scatterplot. This feature is available in excel
-
how to design the function like excel slicer?
I found on others' page, there are function like excel slicer. what function it is? and how to design? hope for the guidance. thanks,
-
Where is the subtotal chart option? thanks
Help: pls see below picture which shows 'enable the subtotal chart option to edit these settings'. I didn't find the subtotal chart option. where is the subtotal chart option? thanks
-
Errors caused by Timezone, Where can I adjust it?
I found the dataset in DOMO is different from the raw data in google sheet for DATETIME field probably due to time zone different. Where can I adjust it? thank you so much.
-
Beast mode for the substring_index
I'm trying to extract the substring from an URL. URL: www.ab.com/level1/level2 I'm looking taking the level2 out of URL. What is the beast mode formula I can use here? I want to get: level2
-
What Date Filter to be chosen to get the data for Saturday on a Monday if Sunday is a Holiday ?
My Plant operates for 6 days from Monday to Saturday. Sunday is a Holiday. I want to schedule a report for Monday that can fetch me the data for Saturday. My scheduled report is working fine from Tuesday till Saturday fetching the previous day's data correctly but it is not fetching the correct data on Monday. I have tried…
-
Last Modified By details in Governance Dataset
We are trying to find the details about last modified by details from the DOMOGOVERNANCE dataflow, but we are not able to see the details.
-
Variable Combination Suggestions via Color Enhancement
We have used text based variables to allow users to select from multiple metrics to see in a single card. This can be very powerful when combined with the recent beast mode within a beast mode feature but one downside is that consolidating cards into one removes one of the benefits of a higher number of cards which is that…
-
Calculating Percent of Total, and Getting Correct Totals
I have this table where I'm using count(distinct()) to get counts of various attributes, but when I add a "Percent of total" column to each one, the percentages add up to more than 100%. In addition, my totals at the bottom of the counts are incorrect. I've attached a screenshot of the issue along with an example of the…
-
Beastmode field not aggregating in bar chart
I have a dataset containing the following data: The Sessions field is a beastmode calculating the rank of the customers phone number. (Running total of how many transactions they have) rank() over (partition by Location.ID, PhoneNo order by TransactionDate) I am wanting to create a horizontal bar chart with the number of…
-
Create a JSON API with Domo
Has anyone had any success in using Domo to build an API for external system to connect to receive structured JSON data? The JSON writeback connector KIND OF handles the PUSH component, but it is severely limited by its 100 row output limitation. And for GET requests, it seems the Domo API outputs data in its own format…
-
"Documentation Mode" in Magic ETL/SQL
A toggle next to "Try the new Magic ETL" would read "Documentation Mode" and would: Put an opaque film over the whole Magic ETL map Disallow changes to the tiles Enable the ability to draw and color-code sections of the ETL Be able to notate what each section is doing An additional item in the Save menu would be "Save and…
-
Deployed Excel sheet with add-in is getting an error
I've deployed an excel sheet with the Domo excel 365 add-in and the user trying to use it gets this error: This document has no imported contents It won't refresh the data. It works fine on my system. Thanks for the help.
-
How to know the way DOMO beast mode 'calculated field' is calculating?
In order to solve the problem at Summary Number, I simplify the data. below is the description of the problem： below is the simplified data: 2024-4-1, data is 1.32, which is what I want to show. 2024-4-2, data is 2.32, which is what i want to show. In Summary Number area, I want the average, that is (1.32+2.32)/2=1.82 but…
-
Dataset by Email Connector: Gmail Validation
Hello there, I am trying to utilize this connector to automate emails with CSV attachments from Gmail, but they require me to confirm this setting by clicking a validation link that is sent. I can see part of the email in the alert below, but is there anywhere else I can access the full message, so I can click the…
-
How to Export filtered dataset?
I have a 1 million row dataset in Domo. I want to filter the data, and only export that data in a CSV. When I filter the data and export, Domo exports the whole 1 million rows, which does not run on my Excel. Anyone know how I can download the filtered dataset>
-
How to get the detailed explanation for beast mode functions?
like Excel formula, there are very detailed explanation for us to learn how to design a formula, they have many examples for me to learn. In DOMO beast mode, I see ' Function Description' is short and not enough for me to learn. I need some examples very detailed materials for me to learn. where can I get them? the…
-
Ability to select different versions of PowerPoint file types to export the data to.
For the ease of access of users on DOMO, it would be good to have a cleaner way to export the dashboard/cards in the latest PowerPoint file type version. The current Microsoft security policy that has been set up prevents our company users from opening the file, since it is an older file type.
-
Making geojson and display it on Google Maps on Domo?
I have two questions: Is it possible to making a geojson from a pivot table or something on a dashboard? Is it possible to display the data and change it interactively? I have some large dataset with about 0.5 billion rows. Because of the size, Domo (or Google Maps, or both?) cannot handle and display the data properly on…
-
Domostats activity log not updating properly
Hi, I am trying to track usage, I have installed domo stats which runs daily however the latest data for my page is November 20th on the monthly version and 17th on the weekly. I know that users have viewed the pages since then. How can I resolve this ?
-
Remap Nulls in Dataset
I assume this is an easy one to answer. If I have blanks in one of the columns of my dataset and want to remap these nulls to a certain value, would it continue to remap new nulls in the future to the new values? Or would it only apply to nulls that are present at the time of the remapping? Basically, our ETL has a formula…
-
Auto add card to every page
Our legal dept. is asking us to add a legal disclaimer to every page in Domo. We have hundreds of pages and this would be a nightmare to manually do and then remember to add each time a new page is added. Anyone know of a way to auto-add a card to the appendix of every dashboard?
-
Can you fix the headers in a pivot table
Hi All, I have a pivot table in my dashboard showing a last 12 month trend in the columns and a list on people in the y column - the issue I'm having is if I filter for a specific person then the columns with no data disappear i.e. if there is only quarterly data my picot will only show 4 columns. Ideally I want to fix the…
-
Data Export an Embedded App Question
Hello, I had a question about the DOMO App Studio. Traditionally we have embedded DOMO dashboards into our customer facing app. We have always used public embed on the dashboard and relied on our company app for user authentication and login. We also do not use and PDP or row level filters in our DOMO dashboards. This…
-
Create a Line Chart that shows the different series while also showing the aggregate of the series?
I'm looking to make a line chart that shows each country region as a separate line, while also showing the aggregate grand total as its own line. Is this possible? If so, how would I go about doing so? I'm attaching one Domo screenshot, and one screenshot from Excel (which is what I want the domo one to look like). Thank…
-
Extract/Export metadata information of entire DOMO App/Dashboard in Json/XML etc file format
I created an entire App/Dashboard end to end having lots of widgets including texts, images, layout, text, cards for visualising a particular dataset which I have created say using Database Connector/File upload What I want to extract/export the entire Dashboard metadata out of DOMO in some file format being it in Json/XML…
-
New feature release 05.22.2024
🚨 NEW PRODUCT ENHANCEMENTS 🚨 This release includes new capabilities that improve ease of use, monitoring, alerts, security, and more. Here are the top five announcements from today's release: 💻 App Studio — Now integrated with Domo Sandbox and with Publish in Domo Everywhere! ⏩ Workflows — Automatically monitor workflow…
-
Trellis/Tiered Date Settings - Bug/Enhancement
When using the tiered date settings on a normal calendar, it displays the quarter and year - It would be good to be able to customise the display format like the category scale. This would enable having one or the other if both aren't wanted. Currently, the Tiered date settings don't appear work with a fiscal calendar. A…