-
Workbench Error converting value {null} to type 'System.Boolean'?
I keep getting the following error on a local excel workbench job. [03.14.25 11:15:36 AM] Error converting value {null} to type 'System.Boolean'. Path '[424].iconPicker', line 1, position 574077. I'm not sure how to fix it. I've tried to fill in null values, but nothing seems to work. HAs anyone had experience with this or…
-
Any way to filter a column by data type?
I am working with a data set that has multiple contributors. Unfortunately many of them enter data their own way. Specifically, I am looking at Diabetic A1C data. One person might enter it is as 5.765, another 5.76%, yet another 5.764444E3, and then another would enter something as 93 MG/L. Is there any formula or DOMO…
-
Save AS ETL not functioning properly?
Hi, I am running into a weird issue. In most cases you can use "Save As" to make adjusted copies of a card or dashboard without changing the original. However, that's not working for ETLs for me. Instead of having a separate ETL, it keeps sending me back into the original. I'm just trying to apply the same name mapping as…
-
Google Ads Connector - Weird Campaign Dates?
Hi everyone, I recently started using the preferred Google ads connector and noticed that all of the campaign end dates are the same. When using the "end_date" Attribute, the campaign end dates all say Dec 30, 2037. Am I using the wrong data dimension? Or is this something that needs to be managed within Google Ads. (I am…
-
DOMO Support should stop closing tickets without prior confirmation from users
DOMO support keeps customers waiting exorbitant amounts of time, then rushes customers to respond or else a ticket is closed. In many cases, DOMO users and managers are tying to coordinate with other departments that they support who may or may not be as tech savvy. The expectation that we as users should have to wait…
-
Editing the email body headers for scheduled reports?
Hi, I have a teammate who would like their scheduled report to fit on one PDF page. However, when sending the report, DOMO includes the phrase scheduled report, the title, the number of cards, who sent it, how many people they sent it to, any filters, etc. Is there any way to consolidate this information? Thank you in…
-
Views keeps converting time to UTC
Hi All, I am having an issue with a dataset. I am trying to extract an hourly occupancy from people's entry and exit dates and time. However, Views keeps converting the times from Eastern to UTC. I have checked, and my company's time zone is already set to Eastern. I'm not sure what to do from here. If I do an offset in a…
-
ETL not joining despite matching columns
I am trying to join an ETL, but for the life of me cannot get the join to work. I have double and triple checked that the columns are formatted the same, trimmed on both sides just in case, etc and Magic ETL still won't recognize that the data matches. What should I do?
-
Solved ETL - Replace Null Values
Hi, I have a dataset with null values and text and I am trying to replace them with 0 and 1 respectively. But, when I try to write a formula using the conditions 'If Null' or 'If not null' I keep getting errors. Does anyone have any ideas? Thanks! Edit: I figured out what I was doing wrong.
-
Admin can't update connector passwords
I recently had to update the password for a connector that was assigned to another team member originally. However, I could not save the new password even though I am an admin. Is there a way to make sure admins can update connector passwords even if they're technically not the owners?
-
How can I keep my data's time zone consistent? 24 to 12 hour conversion issue.
A colleague of my is uploading data currently in 24 hour time into workbench. But, DOMO unnecessarily converts it from UTC to EST when he tries to change it to 12 hour time. Is there a way for us to stop it from adjusting time that's already in the right time zone? Thanks! 🙇
-
Instagram Business Connector Disabled?
Hi All, I am trying to set up the Instagram Business Connector and the assigned team member got the following error: So, we tried setting up the normal Instagram Connecter and got this error instead: Has anyone encountered either of this errors? If so, do you know of a workaround? Thank you!
-
Not sure which join to use
I am trying to link 2 datasets to show scheduled appointments and web traffic in the same visit. The goal is to show what, if any, correlation there may be for traffic to specific ad campaigns and appointments for their related services. When I use datafusion or etl join, it gets messy because the only matching data I have…
-
Combining 2 cards? Trying to find out how to use advertised feature.
At the 1:15 mark of this ad, the user mentions combining two cards showing different but related data ending with an "overlay" of the 2 visuals at 1:50. But, it didn't go into the specifics of how it was done. Does anyone know what feature would allow this? As always, thank you in advance!
-
Instagram Connector Issues? Met Business Suite related
Hi everyone, I am trying to build cards/reports from the Instagram connector, but it fails to pull any reporting metrics. I think it's because my company's instagram is managed through the Meta Business Suite. Do any of you DOMO experts have experience getting Meta Business Suite and the instagram connectors to play nice?…
-
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…
-
Beast mode to generate Batch Date?
Is there a Beast mode that can generate Batch dates? A colleague of mine has a dataset that updates monthly, but does not include a date column. The internal clients who view the report would now like to see a breakdown by date. Is there a way to use a beast mode, or some other tool, to create a batch date calculated…
-
Angled Data Labels?
Is there a way to angle Data Labels on a bar chart? I have a grouped bar chart, so the data labels are vertical to fit in all of the data. I get that it becomes horizontal once you hover over a specific value. But, I'd like people to be able to read it without having to do that. I tried using the rotate selection on the…
-
How can I convert an Excel date code into a normal M/D/Y formatted date?
Hi All, I have some data that I link to DOMO via the Google Analytics connector. It's provided by a 3rd party and contains dates in Excel codes in their 4** format. Is there a recommended Beast Mode or other way to fix the date formatting? Due to IT policy, I can't access google sheets to change it manually. Plus, I would…
-
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…
-
Are there any workbench reports available to show configurations for all jobs?
Is it possible to get a list of all directories and files used by Work Bench without having to go through each job one by one? My colleagues and I are working to clean up our workbench instance. One of the issues we've run into is that the jobs are pulling from personal folders that we don't always have the permissions to…
-
Build a "Meta Business Suite Connector"
The Instagram Connector can't find my company's data because it's managed in the Meta Business Suite. It would be more convenient if there was direct connector to link all of Meta's divisions Facebook, Instagram, etc. when managed this way.
-
One of my bar charts won't display properly in the dashboard.
Hi, everyone! I have a card which shows up properly in analyzer, but does not show its bars in the dashboard or when I click into the card for a drilldown. The weird thing is, if I hover over another card as if to filter a time period, the data will show up. Our management and executive leadership regularly access this…
-
How can I fix a workbench job where the Schema is locked and doesn't match the dataset?
Hi, everyone! I'm running into an issue with the workbench and can't seem to find a solution. One of my jobs has the work bench schema messed up and is pulling nonexistent headers. I'm not sure if it is getting this information from a previous upload but it doesn't even match the column names or number of columns. I…
-
Can you give someone editor privileges for a specific page or card?
Are there any custom options to set set editor privileges by card/dashboard? I am struggling to find any in the admin section.
-
When formatting one series, all numbers end up changing into percentages.
I am trying to build a card that includes percentages as well as totals. Rather than having viewers have to do the mental math off converting .6 to 60%, etc. I just wanted to have the data already multiplied by 100. But, when I change the settings for that one column, Analyzer changes all values to percentages whether I…
-
Rookie Question - Reordering data columns for drill-downs?
Hi, I was looking into one of my cards for a presentation and noticed that the drilldown table is in different order from the source xlsx file. Is there a way to fix this?
-
Admin question: New hire was added to Domo as "social" role, but not recognized as a user
I wasn't sure where to put this, but I am trying to update some new hires' DOMO access. Their director had invited them to see some cards. So, they now have profile's in DOMO. But, I get a "Failed to update user[...]User does not exist" error message if I try to upgrade their access to "participant" or above. What should I…
-
Google Sheets Connector Fails Daily
I recently started using the Google Sheets Connector to automatically connect data shared with me via Google Drive to my Domo dashboards. Most of the files run perfectly. Bur, one consistently fails and I have to resubmit it. I have checked a number of factors: 1) No file or sheet name changes have been made 2) I set it…
-
Data Governance and Organization Best Practices
Hi, everyone! I was hoping that you all would be open to sharing some best practices in terms of organizing/cataloguing datasets, cards, and dashboards to ensure that that team members don't accidentally duplicate each others work. My teammates and I use Domo to support different departments. But, there is occasional…
