-
Admin Question - Unable to move page?
Hi DOJO fam! I'm in a bit of a pickle. 🥒 I was rebuilding an unwieldy dashboard that was shared with a lot of stakeholders, but didn't want to interrupt their access. So, I built the new dashboard as a sub-page. 🤔 Now that it's been approved by the folks who use it the most, I am trying to replace the original…
-
Feedback Survey data from Hubspot into Domo
Is anyone familiar with pulling Feedback Survey data from Hubspot into Domo? I have searched all throughout the hubspot connector but nothing is clear as to where this data would be located if it is being pulled into Domo. I've done trial and error with different reports you can pull but have not had success in finding the…
-
Email Notifications to Users
Has anyone ever had issues with users not getting emails from Domo? I have a handful of users, all from the same department, not getting scheduled reports. When I started looking into it I found they are not getting anything from Domo, no notification or reports. I checked their profile settings and notification settings…
-
Have you upgraded Domo SSO successfully (or unsuccessfully) to Azure AD?
We tried to upgrade Domo to Azure AD yesterday. There was an issue getting the AD groups to synch. I was wondering if anyone has been able to successfully get this to work. I’d also be interested in hearing if anyone attempted and it failed. If so, I’d be curious if you were able to figure out how to remove the AD groups…
-
Is it possible to create a table showing appointment availability in Domo?
I have a list of appointments scheduled with their start and end times, I've created a pivot table showing all appointment start times as the row and closers are broken out into columns. Through an ETL, i'm able to count the number of appointments scheduled at that start time but what I'd really like to do is mark off each…
-
What are the est practices to maximize speed and minimize data storage when updating a large dataset
What are the est practices to maximize speed and minimize data storage when updating a large dataset? I have an example but any tips on performance I'm willing to hear. We have a dataset that consists of an initial load (~ 1 million records) and a daily* update of ~ 20k records (and growing). Within the first year we…
-
Sandbox
How do you add a dataset in sandbox? Not finding much documentation
-
Activity Log Action Definitions
Does anyone know of any documentation that includes the definitions of each "ACTION" in the Activity Log? The KB article below shows a list of tracked events, but no details on what specifically each one represents. Most of them are fairly self-explanatory, but there are others that aren't as obvious.…
-
Fixed to Flex Date selection
Hiya, does anyone out there know best practice (if possible?) to set more dynamic date ranges? Say I want to display “campaign to date” e.g. launch was on 2/4/2023 and I want my dashboard/cards to display data from that fixed point through [today] (variable) — how is this achieved? The only options I can see are either…
-
How to get Last Week/Last Year/etc through dataflows
A lot of premise here so bear with me. I have a dataset containing financial data for a 14 day period (Sold Units, Retail, Expenses, etc). Every 14 days I upload the latest data from the raw source online. I load that data into Domo workbench and have it append the new data so that everything is in the same place. So each…
-
Manual update and auto update?
Morning, I am looking to move a google sheet into Domo. My question is we have people inputting about 20-30% of the data and the rest is sitting in a couple other data bases within Domo. Is there a way to both update that sheet by tying it together with and ETL from other sheets yet still retain the ability for user to…
-
CONCAT function not working, any reasons?
I've done what I'm trying to do before, CONCAT(column, ' ', column) as a calculated column in a view. It's not working anymore for some reason. Any reason why? It's only letting me not do it on certain columns
-
Scheduled report is empty, but I'm the author of the report
I have a daily scheduled report with an attachment that keeps coming to me with no data. Any workarounds? I want the email with the spreadsheet attachment of data. Yes, the data has PDP on it BUT! I am the author of the card, and I have permissions to see all the data in it. When I was testing the card, I kept using the…
-
A more flexible way to do Period over Period comparisons
Greetings! I see variations of this topic asked several times so I thought I'd write up all of the information in a singular spot for easier reference. Below I'll outline how I utilize my own date dimension table to have customized period over period charts, compare the current partial month to the same amount of time in…
-
How can I know the departments that have access to cards/dashboards?
Hello DOMO - Good Day! Is there a way to get a DOMO card to show a report of people's departments which departments has access to card/dashboards? Thanks
-
Who has access to Cards and Dashboards
Hello DOMO - Just wanted to ask if there's a way to get the people or groups that have access to a page or dashboard? We created groups to use to provide access to cards and dashboards. and we wanted to create a card to know who are those that have access to cards individually, those that were added to the cards or…
-
Network Access from MagicETL?
Am I correct in surmising that whatever environment runs Domo's MagicETLs restricts internet connectivity? I've got a few Jupyter workspaces that a colleague has set up to do various things with our data--mostly normal/conventional stuff, but he's also doing a few things that require network access, like sending emails,…
-
Printed dashboards
Is there any functionality that I can schedule a report to be printed to a selection of printers? Some areas want a physical paper to use between Colleagues.
-
How can i control Wordcloud using Variable Input ?
I am showing sales by Dept on a word cloud, but the levels can be changed to item levels and it gets clunky, wish i could control it with a variable input like showing 10% Today i can create the variable and use it in beast mode, but cant use it in the limit field. Looking for bright ideas or work arounds?
-
Counting rows with a specific numerical value when using 'Group By'
Hi there - I'm new to Domo so apologies if this has been asked before and I have been unable to find the answer. I am using the "Group By' function in my ETL and in one of my aggregate columns I want to show the count of all the rows that have the numerical value of 80. I have tried the formula COUNT(`ptstatus`= '80') and…
-
User Group Hierarchy Question
Hi, a Quick question about User groups in Domo can I have a group within a group. in user management. example I have users Jhon,Bob,Joe they are in group A. I create Group B but i dont want to include Jhon,Bob,Joe one by one. Can i reference Group A in Group B. basically, like Active directory . child parent groups ??
-
Why do all Redshift Datflows (still) convert all variables to lower case?
Hi, we're currently doing an audit and noticed that legacy datasets have 2 versions, with the 2nd version just capitalizing the variable names (often a magic ETL). The first version is in Redshift - building dataflows in redshift is quite popular within our team because it has fuctions that mysql dataflows doesn't have.…
-
Please URGENT ***Dashboard on DOMO***
I have this Qlik dashboard and I would like to develop on DOMO, but the most important thing is that I can dynamically compare between years, for example, 2022 x 2019, or 2022 x 2021
-
Magic ETL -Combine Columns
Hello, I am trying to connect 2 columns from Snowflake Data Set nd I am using ETL "Combine Columns" function, but it's giving me an error - attached print screens. Any idea what's wrong? Thanks in advance
-
Disable Directory Groups
When we set up SSO we imported all of our Active Directory groups. Well there are way too many of them making it hard to manage groups in general so I would like ot get rid of them. I unchecked the box in SSO that says import Directory groups and remove the passing of directory groups in their actual SSO setup. The groups…
-
Can someone help me with the syntax?
I am not sure why i am having such a hard time with this one but my brain is not putting the logic together very well. I'm trying to create a calculated field where we are adding the total loan counts from 1st and 2nd mortages by date. Right now we have them split. I have been trying a fixed by function but I am not sure…
-
Is it possible to recreate the SUMIFS formula in DOMO?
I have been trying to recreate the SUMIFS formula from excel in DOMO for a while but have had no success. Would something like this be possible? Thanks!
-
How to use variables for time comparison?
Jace Mclean has shown in the video published on Domo youtube channel that it's possible to use variables as date selector combined with time comparison (PoP vs YoY). This is exactly a business case that I have in my project. My question - how this setup was created? What changes to the dataset/ETL were done? What beast…
-
Webhook for a Report
Does anyone know if there is a way to add a Webhook to an alert that would trigger Domo to send a report? I want to send one of my users a report but only when the alert is triggered.
-
Copy an entire dashboard
Is there a way to copy an entire dashboard and just rename it? My company wants to recreate the exact same dashboard but have one that display fiscal year and calendar year with the exact same formatting. Besides going through each individual card and formatting the dashboards that way, is there a quick copy and paste…