-
Need Tips for Optimizing Data Visualization in Domo
Hi Domo Community, I'm working on improving data visualization in Domo and would love your tips. Any advice on creating dynamic dashboards and using advanced charting features? Thanks,
-
How to create a dataset based on another dataset
Hi everyone, I would like to create a calendar table based on an orders data base, based on min and max date from that. Do you know a way to do it? Thanks for your help Eduard
-
Moving Dataset,cards,dashboards between different domo site
Hi Team, We are planning to move the domo cards,datasets,dashboards created site1 to site2,site3 etc. Can any one suggest best way to migrate all content from one domo environment to other. Ex: j&J.domo to DCA.domo,JON.Domo.com
-
How can we create a Dataset from Excel in DOMO?
-
I want to host a webinar on how to automate all manual uploads into DOMO
If you find yourself spending an hour or more every week manually tweaking and uploading data to DOMO, I want to help show the DOMO community how automation can help streamline your efforts where a connector or integrations don't exist or resources are not available. If this sounds like something you would be interested in…
-
Keeping 0s in front of an integer (ID numbers)
Hi, everyone! I have a file that has ID numbers about half of which have 0s in front. When I upload the dataset through workbench, it drops the zeros even when I have it set to integer. I am trying to merge this data set to another using the ID numbers as a matching column. But, one dataset kept the 0s while the other…
-
I need to know what is the date 5 previous business days from current day, including holidays
The domo data set for calendar has columns for isHoliday and is workday, but how do I find the 5th previous day from a given date that contains 5 business days. For example, if the date is 11/28/2022 it should return a date of 11/18/2022 because there is 1 holiday (11/24) and two weekends(total of 5 non working days).…
-
Domo Webpage
My org chart in Domo is fed by a webpage. I updated my web page and my org chart is not loading anything. I am not sure how to troubleshoot this. Any help is appreciated
-
Need help with Beast Mode for specific time period
I'm trying to create a beast mode that calculates revenue for jan-jun and then july- dec SUM(CASE WHEN Month(Period) = MONTH(CURDATE()) -6 AND DAYOFYEAR(Period) <= DAYOFYEAR(CURDATE()) and Item THEN a_amount END)
-
Appending new data in DOMO
updating the domo dataset every month with the latest record without doing the manual import. suggestion needed.
-
PDP
Hi, Just out of curiosity, is there a way to remove PDP from a specific card but keep it on the others? I accidently created a card with a dataset that has PDP and I'm trying to avoid the long way of fixing it of copying the dataflow, turning off the PDP and recreating the card. Thanks in advance!
-
Is there a way to be notified if a dataset update is taking longer than "x" minutes?
Every once in a while I'll have datasets take significantly longer to update than normal. (Ex: "DataSet A" has a normal update time of 2 minutes and occasionally it'll take 3+ hours to update). Is there a way to create some sort of alert or notification that'll let me know when these anomalies occur? For example, I'd want…
-
How do you calculate a percentage using two different count(distinct) beast mode calculations?
I have a data set that contains the following columns, training id, employee id, training question id (each training contains multiple questions), training completion status (i.e., passed, failed, to do). We have this beast mode calculation to identify the number of employees that have passed the training: case when…
-
How can we stop the dataset from disabling with time automatically?
In such cases when dataset is not being used but we also do want it to disable automatically , is there any way to keep it running over the period of time???
-
Assigning Students to Various Organizations
I have a student data set and an organization dataset. In the student data set, the students are ranked by a "matching score". In the organization data set, there is a list of organizations that need to fill 'x' number of vacancies (the vacancies vary by organization). The organizations are also ranked by a priority. The…
-
How many datasets we can join/union in view explorer?
-
What are the row limitations of dataset views which we create using view explorer?
-
Joins, Appends, Unions examples
Joining data can be difficult to understand and use properly, here are a few examples of good join/appends/unions. Take a look at the example page for examples of data options. Click here to see the full details on our publicly embedded demo page -
-
Way of Disabling Data Profiling Characteristics?
If you're using a view to join tables on Redshift, is there a way to disable data profiling characteristics?
-
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,…