-
Trying to append data from databricks
Hello, My requirement is to pull the data - run a query 90 columns from databricks table for 12 month which is around 2M records of data and append it to the existing dataset via API Since its the large volume of data, I'm getting error as '"status":400,"statusReason":"Bad Request","message":"Too many non-consecutive part…
-
dojo registration via mobile device does not require subdomain
I registered dojo through my android phone, and the subdomain is not required.
-
Excel Sheet to Domo
Hi Everyone, Happy Friday Eve. I have a shared Excel workbook with multiple sheets that are appended together via power query into a master list sheet. I'd like to set up a Domo connector to pull from this master list sheet only. Is this possible? What is the ideal connector for this, and where is the ideal place to store…
-
Can we include the filename in File upload connector for xlsx file
While creating a dataset using file upload connector for xlsx file, can we update the configuration of it to include the filename as well? I understand that there is an option with the Legacy file upload connector but only that is only with CSV and not with excel.
-
Dynamic alerting in Domo
Does anyone know of a way to do any dynamic alerting in Domo? I don't want to create an alert for every individual who may meet the alertable criteria.
-
How do I restart automated report emails after an unsubscribe?
I was sending a report to a company Google group until someone in the group unsubscribed from the report. Apparently, that individual action unsubscribed the entire group from the report. Now, I am no longer able to send the report to the group. After I reset the report for sending, nothing happens. I now have to manually…
-
PDP: Using Not Equal To a Value
I have a column that needs to be used in PDP. There are 26 values in the column (that may get renamed or added to a few times a year). I have a group that needs all the Values except for 1. I am wary of adding the permission and selecting the other 25 currently available given there may be a change in the column values…
-
Field Use Export
Is there a Governance connector or way to filter to a dataset and determine which columns are used in cards/beastmodes?
-
How do you separate data in a column
I have a column that lists all our engagement types (call, email, meeting, text, note, and task). How do I get each engagement type to be their own column instead of all being in one? I’m trying to create a gamification points system. We want to give the salespeople 5 points for every meeting, 2 points for every call, and…
-
Outage/Long Load Times
Anyone else experiencing service disruptions this morning? I'm struggling to load pages, save ETLs, load cards, etc.
-
CY vs PY and Multiline Chart
Hi All, I am trying to build a multiline chart that would have 2 Y-axis line chart. Y1 Axis to show Cumulative Line of YTD Sales vs PY to Date Sales and Y2 Axis to show YTD Average Sales vs PY to Date average sales. I have tried all the available line charts and seems not to be the one as per the picture attached. Also,…
-
Help Pivoting Data
I have a file where I want to have each row show me the charges based on either the charge code or charge name. In this example, I used the name. I have looked at the data online, and in the ELT. The problem with I’m seeing in the ELT is I would have list the name of every code we have in the number 3 position (shown in…
-
Do you know if Data views can be materialized to be used as input datasets in Adrenaline data flows?
-
How to build a filter for only the most recent value of a column in a data set to show.
I've got a dataset of patients for my hospital and each patient has a unique medical record number. The dataset has multiple visits from the same patients and each visit gets a unique account number. Each visit there is also a calculated readmission risk score. I'm trying to build a filter either in the ETL or on the Domo…
-
Best practice for removing historical values
I have a snapshot dataflow that has captured bad values. I only need to filter out those values that don't match the current format. What is the best practice for this?
-
Forecasting best practices
Hi could you please share some best practices of forecasting?
-
Domo Consumption/Usage Model
Hello community! I am curious who out there has switched to consumption pricing and what your experience has been? We are considering switching and would love to hear how the change was for those that have! The good, the bad and the ugly.
-
Dataset Change Log
Scenario - I have a dataset that I change once in a while i.e - Adding/removing column from source. Question - I want to keep track over the changes made on the dataset configurations in DOMO, is there any place where I can track this in DOMO?
-
Dataset to display the underlying DB table/view in Overview Tab
It's good to know the underlying databse table or view on which the dataset is created in order to backtrack any issues. In case developer of the dataset leaves role/org it's difficult to find the datasource table/view name.
-
Is there a way to get a list of all fields being referenced in cards by a dataset?
I'm just looking for a quick way to get a full list of all fields being used in cards/beast mode calculations or any other area. For example, we use hubspot connectors which bring all hubspot data into domo. I want a list to see which fields from hubspot we are actually referencing in domo.
-
Dataset Archiving Parameters?
We recently had a dataset auto-archive because it was not accessed in a long time. Can somebody explain what the parameters are for when Domo will decide to archive a dataset? Additionally, is there a way to prevent this from happening with a specific dataset? Regards, Jack
-
Is there a way to rebuild a connector to allow for partitioning?
I use several connectors that do not currently have partitioning capabilities. Is there a way to rebuild them to allow this capability? For example, Facebook, LinkedIn, etc do not have the merge option.
-
Paritoning beta. Where to start?
I've got access to the partitioning beta and trying to figure out where to start. I have a number of legacy datasets (marketing platforms like Facebook, LinkedIn, Google Ads and Google Analytics) and dataflows that are clunky at best and go the long route to handle recursive data. I'm looking to simplify and make these…
-
Effect of DataSet View Calculated Columns on Performance
I want confirmation that if I shift over a bunch of dataset view calculated columns to run in the dataflow instead of on the dataset view that I can potentially boost the performance of my dashboards. Currently, the dashboards run okay, but filtering takes a while. The dashboards are heavily leveraging COUNT(DISTINCT()),…
-
Trying to Split a Text Field with Time data (HH:MM:SS) into usable data
I am trying to split up a column using the ETL. The field is formatted as TEXT and has both HH:MM:SS data and MM:SS data (not uniform). I need to convert it to a uniform format so I can break it down into Hours, minutes and seconds of time (End result I am going to add it all up to seconds). After splitting I will convert…
-
Tracking Datasets connected in other DataFlows
Is there a way to track if a dataset is connected to another data flow? Developing a card right now that looks at if a dataset has zero cards in order to see if we need to keep the dataset in domo. If a dataset has zero cards but is connected to another dataset via dataflow, I will want to keep it in domo, otherwise I want…
-
Removing or anonymizing PII data?
Is there a best practice approach customers are using to remove or anonymize PII data for former clients? (tools, other clients who may have done this, etc.)
-
What are the best options for concerns about co-mingled data
Clients concerns about co-mingled data and possible options other customers are using?
-
Does a slicer work even if I'm using a sub dataset?
Hello. Hope someone can enlighten me or help me if there's a solution for this: I need to use one slicer for my dashboard, which contains like 16 cards. The slicer should be able to filter all cards in that dashboard. Here's my problem: I'm using three datasets for the cards in the dashboard: Main Dataset - let's name this…
-
Is there a way to clone a dataset?
Hi, is there a way we can duplicate a dataset? Thank you