-
Help with creating just one single column containing different time frames
Hi, I want to create a column that states the time period. I essentially have a dataset that consists of data that is divided across quarter, month and year. For example I have data that displays revenue for the current month, revenue for the current year and revenue for the current day. I want to create column that uses…
-
How to reduce Magic ETL run time
Hi Everyone. I'm looking for a way to reduce the run time of Magic ETL 2 data flows. The ETL takes about 3 hours 30 minutes to run I'm working with several left joins and formulas in sequence on about 12 datasets of 10k rows each which generates an output of 30k rows. Beyond this, the ETL performs no other complex…
-
Forecasting Next Quarter's Data
I am trying to take the current month's visits/ Working day to forecast the next 3 months total visits per month. I would take current month's visits/ working day * next month's working days. I want the card to be interactive where there is a visits/Working day control toggle as well. I am getting stuck on the date formula…
-
Domopalooza Live Stream
Does anyone know if there is going to be live stream of Domopalooza presentations?
-
Job Board Status
The Domo community job board is great. But it is just an infinite list of discussions that are job postings, without any way to see if a job is still available. This causes two problems: 1) Jobs that could still be hiring get buried by new job postings, decreasing the visibility for the hiring company. 2) When someone is…
-
Pivot Table Collapsing
Hi all, I used to have this card setup so the pivot table was expanded out one level and it worked fine up until a month ago. When I view the card all levels are collapsed in the dashboard view. If i go into the card to expand it out and click save, it keeps defaulting back to a fully collapsed view. This didn't happen…
-
Replace personal identifiable information with avatar
Has anyone ever replaced a user's information with a non-identifiable avatar in a table on a dashboard? Here is the use case: We want to show a snapshot of what was recently watched on our video streaming platform. Our model is that a group buys a subscription, and then all its members can use the platform and watch…
-
Showing min, max, and average lines for chart with Series included
Following up from discussion here: This has been closed. But my suggestion is to offer this as a feature / option: Create min, max, and average lines based off of totals. A second option can be to create color-coded min, max, and average lines based on each individual Series, but unless there are a very small number of…
-
Compare values in a series against overall average
Hi Domo community, I'm looking to create a card that shows which segments are bringing our Net Promoter Score (NPS) up or down. My idea for a visualization is below. The centre line is the monthly overall NPS and then the 4 bars (International, United States, Canada, and regional) are the series that show the different…
-
File Import Schema
I often get frustrated by Domo's need to define its own data structures. It might get quite a bit right, but what it gets wrong becomes a problem. In the file import, I see no way to define the data structure for each column. The best I can do is force the data type in the source file and try to trick Domo into creating…
-
If date falls within the current month
I am trying to calculate the # of visits (that a therapist does) per working day against a goal of how many visits per day we budgeted them to do in a month. I am running into an issue with the calculation for the current month. For example, the goal for June was 22 visits a day and we had 733 visits in the month of June…
-
Cloud Amplifier - Databricks - Unable to retrieve schemas
All my catalogs can be retrieved/validated just fine except for one that returns the "Cannot retrieve schemas" error or "Cannot validate table" error. I've attached screenshots below. 99% confident this is a Databricks issue but cannot pinpoint what is different about this catalog vs the others… I am using a personal…
-
Upload large JSON files
I have a JSON file located in a google drive folder, the file is 12GB so is too large to use the file upload connector. Is there a workaround on this to be able to upload the JSON file into Domo whether is directly from the computer or importing it from google drive?
-
Is it possible to pull image into the tables?
-
Beast Mode Approach to Eliminate Field Character
I have a data set of email addresses and i've used a beast mode calc to create a new field for the domains. RIGHT(Sent Email,((LENGTH(Sent Email))-(INSTR(Sent Email,'@')))) The issue I'm having is that some of the email values also include the bracketed name of the user so some of the results are coming back looking like…
-
Is there any way to incorporate search within a table?
I have a table in my dashboard (see attached image) that I would like to incorporate search into. Is this possible?
-
PPT Add-in: Ability to bulk import cards
In the current PPT Plug-in, you can select multiple cards to load into PPT all in one import. In the new PPT Add-in, you have to load cards individually one by one and then select settings for each card before importing into the PPT. This will be take a lot of time when we have to recreate our PPT templates
-
Text to Wrap Breaking Up Whole Words In Column Headers
I've run into this issue a couple of times now on different cards, so figured I might post this on the ideas exchange. When using the table chart type for a table with numerous columns, I'm periodically running into an issue where Domo will cut off whole words onto different lines instead of formatting the column width so…
-
Sandbox - Dataflow scheduling
When promoting a dataflow from one environment to another, I would like the option to retain the dataflow schedule from the source instance in the destination instance. I would also like the option to execute the dataflow automatically once promoted so that dependent Sandbox jobs downstream do not result in errors because…
-
Add dynamic columns in variable dashboards
If Domo has the option to add dynamic texts in columns, that would be super helpful for variable dashboards. Currently, I have variable buttons of TY, LY, TW, Last 2 Weeks, etc, and Spend 1 and Spend 2 as column titles but if we can have TY Spend and LY Spend and TW Spend, etc. as the column titles, that would be an…
-
Dynamic Column Names in Tables
The introduction of variables allows you to create much more dynamic table cards where the user can pick and choose which columns he/she wants to see inside the Table/Pivot Card. However, Variables only changes the data that shows up inside the table, it currently can not affect the Column Name so i have to end up naming…
-
how to utilize multiple date columns that has values for showing the trend
I have dates for each month for a total of twelve months ( 12 columns), each column has a value under it for every chapter. Now i want to utilize the chapter , the twelve columns to showcase a graph that has trend for year to date. How do I achieve this?
-
How do I search for rows containing specific text and replace the information in that row?
I have a column in my ETL dataset that is named "City", in that column there are multiple city names however they have been put in in all different ways (ie: st george, St. George, ST George). I would like to search that column for rows containing 'george' and replace the information in that row with 'St. George'. I've…
-
Configuring Card for Last Time Federated Dataset Refreshed Based on Browser Time Zone
Hello, I am trying to visualize in a card when the last time a federated dataset has been refreshed based on the timezone that a person's browser is set to. For example, if I see that this dataset last updated at 2 PM and I am in the Eastern Timezone, I would want that a person in LA time see that the dataset last updated…
-
How to change colors of the chart based on timeframe
I am trying to change the colors of current month and future months a different color than past months. Past months show actual values and current/future months show forecast values. How would I go about doing this? What I would like is past months to be the current color below and current/future months to be a lighter…
-
Alert Configuration options differ across the DataSets
Good afternoon all, I am looking at setting up the Alerts on our DataSets and have noticed that the options for the configuration differ between different DataSets even though they are both powered by the same Connector. Version 1 - provides the option to apply the alert on the indivduals rows and apply filters (the one…
-
Add Users to Shopify Custom App Connector
There is no Users option for the Shopify Custom App Connector, therefore there is no way to join the User ID on Orders back to an actual User Name.
-
HappyReturns API
I am looking to set up a custom connector for HappyReturns webhooks. Has anyone done this before?
-
Hi , Am getting the error while saving the card
This error " There was a problem saving your card, If the problem persists, contact Domo Support Team. Please assist on this.
-
Add a governance dataset for DataFusions to identify datasets used as inputs
Governance data is readily available to identify input datasets for dataflows and dataset views, but there isn't a governance dataset for DataFusions that allows the same. We need the same visibility into how DataFusions uses datasets as any other object in Domo.