-
How to grant permission for a user to access an ETL dataflow?
I have a privledged user that has access to the dataset however he can't seem to access the actual ETL dataflow. How would I go around doing that? Thanks
-
Scatter Chart - Drilling Down
Good morning, I've attached an image of a card a user has built using a scatter chart. The X Axis represents the day of the week, the Y Axis is the amount of hours it takes for blood products to go from collected to labeled, and the bubble size is the count of products that land in that hour time period. When we want to…
-
PDP on Columns?
I saw in the idea section this post: https://dojo.domo.com/discussion/41767/dataset-pdp-for-columns But comments are turned off. I have a dataset that is powering tons of cards. Users have access to different cards depending on the Dashboard I gave them access to. Are you telling me I have to create a different dataset if…
-
Can I nest a Select Distinct function in a beastmode?
Relatively new to all of this, but I'm working on a beastmode that calculates the average tenure of active employees within my company. The data I'm pulling from includes a lot of duplicate system id's (employee id's). I need to filter out these duplicates in order to get an accurate average. I've written the formula in a…
-
Create a card/text field that simply says the last month on a dashboard
I have a dashboard set up to review the last month. Is there a way to simply get a header or text box in the dashboard that identifies the last month? (each month, it will automatically change - so today, it should say February 2021 and on April 1, it will say March 2021).
-
Multiple Date Fields and Filters
I have one table with two date fields: date-1 and date-2. I would like to configure two filters such that filter-1 operates on date-1 and filter-2 operates on date-2. Is this possible? My experiments so far have yielded inconsistent results. I'm not sure how to control the mapping between dates and filters. Thanks!
-
Participate in a 15 minute survey and receive a complimentary report ($895 Value)!
Make your voice heard by participating in Dresner’s 2022 New Year User Research Survey! The online survey is estimated to take 15 minutes to complete, and responses will be used to examine the state of the BI and analytics marketplace focusing on drivers, usage, and products. As a thank you for your time, you’ll receive a…
-
scheduled Reports - Update email addresses from Dataset?
Is there a way to Programmatically update the scheduled reports list from a Dataset that has the Email addresses using python scripting or any other method? We have a Dataset with Supplier Contacts which we keep up to date for about 400 suppliers. we want to send each of these contacts a filtered report that shows their…
-
Is there a way to show 0 values in line graphs?
Hello! I am looking for a way to continuously graph data, even when there are 0 values. When creating cards, I see breaks in line graphs when there is NULL data. Any ideas?? Thanks, Keirsten
-
How do I turn off an alert on data loads?
Early in my Domo learning, I turned on an email alert that triggers when a dataset fails to load. Now, weeks later, I want to turn it off, but I cannot find the setting for this particular alert, and documentation has not helped. (So I also no longer remember how to turn on these alerts). The alert reads: The DataSet <X>…
-
Best option for YOY comparison showing where we are now to that same period last year?
I am trying to show a comparison for total revenue for where we are now compared to where we were end of February 2021. toying around with different graph options isn't allowing me to slice and dice the way I want. It either is a line graph YOY by month or a progress bar that is using all of Last year and comparing it to…
-
Can I make groups or export groups of non-domo users for scheduling reports?
Hi, We have third party clients whom we would like to send scheduled reports on daily/weekly/monthly basis directly out of Domo. They will be non-domo users. I was wondering if its possible to either export group of email address in domo and schedule a report for such group (group of email ids). Use Case: We have, say,…
-
Summing a Max or Level of Detail
My data has row count information that is duplicated or reported on a Column Name basis. I need to be able to sum the max of each dataset name, or sum by level of detail - column name. For example in the data shown below. The row count for 'KPI DOC DOE SUB BE - SBE as category' is 5,013,614,211 and the row count for 'MKTG…
-
Can I write SQL directly to my data sources?
I know I can click on "SQL" in the top ribbon to write SQL against my data sources using a data flow. However, does Domo provide a direct option? Many of my users just want to open an interface to write SQL and then preview and download results.
-
Checklist to diagnose elongated runtimes from adding one simple join
I have a complex data flow (A) that was taking about 7 minutes to run. I have another simple data flow (B) that is taking 2 minutes to run. Both have outputs that are properly indexed. I created a new data flow that creates an inner join between two of the output datasets from each data flow (A & B). This inner join is on…
-
How to remove a decimal in an area dimension column?
I have a column that showing the dimensions of a unit. 5x5, 5x10, etc.. the column is in a text format and the data is coming in to Domo in a strange way, it looks like: What I want is just the more standard: 5x5, 5x10, 5x15, etc.. In the ETL how could i get rid of the .0?
-
Remove Inactive Users Automatically from Domo.
Is it possible to remove the users automatically from instance after a period of inactivity.?
-
Remove weekend days from calculations
Hi, I'd like to remove weekend days from calculating on time data. For example - 2 day turnaround to be met. Issued on Mon but started on Friday so would meet target but at moment is looking like 3 days. Could anyone help me with a beastmode for doing this - I have an opened and closed date. Thanks, Katie
-
Workbench Installation Fail
Does anyone know what this installation fail means?
-
Right string operation to remove the timestamp
I have a long date that I have converted to a text. Now I want to use the string operations tile to cut off the tail so I can have a nice clean date. the way it looks now in a string format is: 2022-02-24T12:08:34 What I want is: 2022-02-24 What I have been trying is: But it leaving the date unchanged and that timestamp at…
-
Summary Number - "show more options" drop down is not displaying
When I click the drop down of the summary number in the analyzer the "show more options" tab is not showing up under "No Summary Number" Does anyone know the problem or how to resolve? Thanks
-
How to filter for YTD Values
I have a dataset that goes back to 2018 and its format is: Month Day, Year 12:00:00. I was looking to filter for rows only with a data between 1/1/22 and 2/21/22 on ETL but when I try to do this through the filter function, it doesn't display anything even though this dataset is updated daily through a live dataflow. Is…
-
Grouped Bar - Hiding bars at dashboard view
I have a Grouped Bar card. If you go into card view, you can click on the name of the bars in the legend to hide/show them. However, from the dashboard view, clicking a bar name in the legend doesn't do anything. From the dashboard view, is there anyway to hide specific columns? Could it be done through a filter card, or…
-
SSO Synchronize Groups from AD
We are using Domo along with SSO back to our Active Directory. We use groups in AD to determine which cards and data individual users are allowed to view. It appears that Domo does not sync down groups from AD until a user in that group has authenticated. This means that we always have to create test users with new group…
-
Domo Buzz notifications
Hi In Domo Buzz you can start a conversation about a dashboard. But, having tested it, no one who the card is shared with gets told about the conversation unless each individual is @ mentioned in the chat. Is there a setting which alerts all of the people that a measure in the dahboard has been updated? Thanks Ian
-
Rolling 30 Day Formula in magic ETL
Hi, I am trying to write the formula above within magic ETL. Column A consists of static values. Column B starts with 0 as the first value and has the formula shown in the image. The formula resets its count every time it gets to a number greater than or equal to 30. The only way I can find to do this is with a LAG()…
-
Adjusting a decimal to be used as a summary number
I have a column that calculates a %. in the dataset it reflects like 94.965, 97.245, etc. which works great in any card. Now that I am trying to use it as a summary number I am running in to this issue: I can't seem to be able to get it to reflect 94.39%. it just shows this big ugly number. This field is a calculated using…
-
Client Churn ETL
I am trying to generate a data set for client churn by month and I'm running into an issue. I need to be able to calculate total clients (running total) up to a specific month and total lost clients that month. The final data should look something like this. You can imagine there were 5 new clients in November, 10 new…
-
how to aggregate an average case statement
Business task: "what percent of this region's sites beat their target signups YTD"? So I want to take the average daily signup for each site within a region and see if it passes its target. If it does pass, it gets a 1, else 0. After this, I then want to aggregate it to the region level. So for example if 5 out of 6 sites…
-
How can thousand separators be built into a concat() statement in a beast mode for a custom summary?
I found Creating a Custom Summary Number in the Knowledge base on https://domohelp.domo.com/hc/en-us/articles/360043430093-Sample-Beast-Mode-Calculations-Card-Element-Transforms. I have built a custom summary number with the below beast mode that results in "75740929.28 Part Sales Net - February" Is there html code or…