-
Beast Mode Editor Formula List Consistency
The list of formulas displayed in the beast mode editor in the different areas of Domo (Formula tile in Magic ETL, Analyzer, Views) display a different list of functions. The Formula tile contains the most comprehensive list and 99% of the functions listed work in Analyzer and Views even though they aren't listed when…
-
Disable Auto-Preview for Cards (Federated Connections / System Wide)
We currently have a mix of Domo datasets plus federated datasets in our instance. When new cards are created, Domo often picks columns that are pretty irrelevant most of the time. While this isn't much of a big deal for Domo datasets since there is a speed advantage there, it creates a negative user experience for…
-
Remove min/max/avg lines
Was this single click option recently removed from Grid Lines? It was useful…..now I have to click 'Remove min', 'Remove max' and 'Calculated line - None' (after selecting 'None' from dropdown) separately. A backwards step….
-
Thousands separator to be modified in Summary Value
Hello, It would be great to be able to change the format of the thousands separator in the summary value. By default, it is a comma, but as I show data to French people, it has to be a "." Indeed, for other values in the card, I am able to do this by changing the "number format" on the card and setting custom separators.…
-
please add width and height parameter on dashboard edit mode
I want everything in the dashboard to be proportionate, including cards, images, text, everything in my standard because I have high requirements for the aesthetics. However, DOMO completely lack of measuring tools to see the length and width of different components in the dashboard, and it makes me unhappy
-
Allowing Auto-Forwarding of Emails to Email Connector
At the moment a user needs to manually forward emails into domo using the email connector. We would love to be able to turn on auto-forwarding so that reports that drop into our inbox can be automatically send into Domo without having to touch them.
-
Various issues with Scatter Charts
Hi all, I have 4 key issues that are holding back some Scatter charts from being finalized, and visually appealing. Not all bubble labels are shown, even when a bubble is by itself, and there's plenty space for a label without it infringing on another label or bubble. If I turn on Allow overlap, I can see all labels, but…
-
Are bulk uploads possible into a table section in form builder?
If you create a form with a table section, you still have the option to select bulk upload, but when you download the template it is blank. I considered creating my own template by finding the section IDs, Item IDs, section Names, and question Names in the output dataset of the form. I Realized a column would have to exist…
-
Simple Reg ex help
I have rows that look like this: Interview with Bob Dylan - CSM and want to parse just the CSM. I tried using Replace Text file, selecting reg ex and using this: -.* but it returned the former portion. Any recommendations on what reg ex to use?
-
How can I get labels on the D3 Correlogram Chart Brick?
I love correlation matrices for exploration, but Domo's implementation is very tough to get value out of without labeled axes. Anyone know enough about bricks or D3 to guide me?
-
Count Attribute Instances instead of Projects
Hi everyone! In our system, a project can have up to 9 go-live dates. I am comparing our 2023 planned go-lives to the actual go-lives, to determine if they were on-time (with a 25 day allowance) First, I use this BM to determine if the go-live was in 2023: case when Year(Actual Business Go-Live 1 Date_p) = 2023 then 'Yes'…
-
Average of a difference in Timestamps
I have two timestamp fields: completed at and delivered at. I want to find the difference of both and take the average. The dates include a window that is sometimes over a day. I read this By @GrantSmith which is useful. Is there an easy way to do this without breaking up each segment (day, hour, minute, second) then…
-
Changing dataset update method from Replace to Partition doubles data
We've noticed that if we change the update method of an existing dataset to Partition from replace, we end up with two records in the dataset for every new one (and both of them look identical, down to the field we're using for partitioning): it was quite the shock to see a dataset I expected to have 91 million rows…
-
Is it possible to render an exisiting card inside a Domo Brick?
Hi All! Does anyone know of a way to 'embed' an existing out-of-the-box card inside a domo brick? I realize there are custom visualizations via PheonixChart to create custom visuals, but I have an idea for a dynamic, table driven landing page and want to take an existing card URL (e.g <instance>.domo.com/kpis/details/<card…
-
For those using Domo Workbench with Quickbooks Enterprise, how do you deal with modal dialog boxes?
Intuit login, errors pertaining to the qbsdklog.txt file, etc…we are getting multiple errors every single day which hang up all of our Workbench jobs. How does everyone else deal with these? We have implemented a Power Automate script on our servers housing our Workbench jobs, but some of the dialog boxes, particularly the…
-
Filtering 2 different data sets with one filter on a dashboard
Hi there, I have 2 different data sets (orders in and orders out) which both contain customer name. I want to be able to filter on both however domo wont recognise them as one column.
-
Scatter: How do I constrain bubble sizes?
Unless I'm misunderstanding things (the documentation is thin in this area) there is a setting to explicitly set upper and lower limits on scatter plot bubble sizes, as you might do with a bar or line chart. However, nothing I do with the "minimum" and "maximum" bubble value fields seems to make any difference.
-
Difference between excel plugin and excel addin.
When using the excel add from the excel windows store the domo content would disconnect and I would have to reconnect to the domo database to refresh it. Will the plugin provide a better experience? vs
-
Domo Jupyter Notebook Web scraper
Hello I am interested in building a python web scrapper using Selenium using DOMOs online Jupyter notebook. The Domo I don't want to use the Python SDK. The reason is because I need this to scrape daily and if I do this through Python SDK I will need my computer to be on to do this. I only article I could find on this…
-
Managing Data Retention Policy
Currently, there's no feature to create and manage custom rules for handling historical data within datasets. Companies have specific rules on how long they are allowed to keep different types of data and it looks like it is not easy to enforce this in Domo. There should be settings in DataSets where we can define…
-
Issue with Sales Data Tracking and Date Transformation
Hello, I'm encountering an issue with tracking sales data in from our CRM. The problem arises from the fact that the table card relies on the 'Date Created' column for capturing engagements. Although this successfully captures most sales data, it fails to include engagements that were created in the previous year but…
-
Preserve the dynamic page date filter while calculating the aggregate results of diff dates fields.
So my question is essentially this: I have two totals i wish to use for a calculation. The problem is that each total is arrived at using different date fields. If I didn't want to retain the functionality of the date page filter, I could do that in beast mode, but i'd like to exhaust the possibility of retaining that…
-
ETL Pivot Tile
I am trying to pivot the warehouse clean column with the values to show like this: How Would I go about formatting the pivot tile for this? Thanks
-
Formulae function for table instead of line by line
I have two tables. The first table i have a list of telephone numbers. The second table, a list of the first 3 digits of the number. I want to qualify the first with the next. Here is my formulae: case when SUBSTR(Phone,4,3) not in(NXX) then 'no' else 'yes' END so this is fine in that it qualifies line by line. However, I…
-
Can I combine columns to create one column for a pie chart/bar graph visual?
In Salesforce, about 9 checkbox fields track whether a member signed up for that specific event. For example: But when creating a pie chart or bar graph, this becomes problematic because they are all separate rows. Is there a way to combine the data so I can have a member count for how many members signed up for Event 1…
-
'None' response when calling Domo SDK to append data into dataset
I am trying to append data into a dataset I created using the API but I get this error: Failed to import data into Domo: 'NoneType' object is not subscriptable. The dataset is created successfully but then I get that error message when trying to append the data into it. After some troubleshooting I found that the 'None'…
-
Why doesn't the Date Settings feature in Magic ETL update my dates?
When I navigate to Settings and change the Timezone to America/Los Angeles, it doesn't change any of the values for my date columns. However, when I navigate to my input dataset in the ETL and change the time zone on an individual date field, it works as expected. Am I doing something wrong?
-
How do I create a card to display the data in this way?
Display the first 13 columns in a way that only the unique values are displayed, but the rest of values are blanked since they are repeated values from the previous row. Display a new row when the values are different. I have tried multiple ways without success; cards, filters, Magic ETL, … I know I can repeat every row,…
-
SQL formula for blank cells
I have a table with some cells that are blank. I would like a zero to populate in the cell instead of them being blank. Is there a simple SQL formula someone could share with me to change the blank cell to a 0 number?
-
User Tracking Analysis within DOMO Embed
We have deployed dashboards across our member portal using DOMO embed. We are hoping to be able to really track how much time users are spending on a dashboard, which dashboards are popular and unpopular, where are they clicking and how far are they scrolling, and when are they dropping off the dashboard. This is critical…