-
Domo Excel Add-in "Live Data Mode"
I would like to disable "Live Data Mode" in the Excel addin. I've created the excel sheet, saved it, moved it to the business system. On my system, when I select "Refresh all" Live Data Mode stays off. However, on the other system, when I select Refresh All, live Live Data Mode enables again, turns blue. I've tried turning…
-
Excel Plugin - Allow Domo Input/Filtering via cells
In terms of the plugin Are we considering (have considered) any enhancement for allowing Domo filtering to be driven from the actual sheet instead of always jumping into the configuration pane? This would be super efficient for teams that do a fair amount of modeling and simply want to change filters by entering value into…
-
Split out the Grant option 'Export From Domo'
Currently, there's an option to enable/disable users from 'Creat[ing] Scheduled Reports and export[ing] to email, print, PowerPoint, CSV, and Excel.' I would like to retain the ability to share the cards/dashboards but would like to have an option of preventing users from accessing the underlying data behind the chart…
-
Domo Office Add-In - Relative Date Filters
Hi, the legacy version of the plug-in that our users are widely used to had the ability to do relative date filtering. Unfortunately, the new version does not include this functionality and is hindering our effort to get users to upgrade. Please enhance the new add-in by adding relative date filtering.
-
OneDrive for Business Connector Not Uploading Recent File Version
I updated an excel spreadsheet this morning that is set to be uploaded through the Microsoft OneDrive for Business data connector. The initial upload worked without issue. However, it's been 6 hours since I updated the file and everything I click "Run Now" for the dataset, it pulls the original version of the file. I have…
-
Excel button to refresh data
Hello, I have 2 questions. what is "live data mode" in the Excel O365 add-in? Is there a way to create an Excel button which calls Domo Data Refresh all, instead of using the file menu at the top to refresh the data? Thanks for the help.
-
Date and Time formatting
Hi all, I am uploading an excel file into domo - we are hoping to be able to do this through the workbench eventually but, for now we are doing it through a manual file upload. In the excel file, we are tracking lapsed times for our call center. When I take the upload the data from excel in an elapsed time format (1st…
-
Refresh an excel file that has data and a pivot table
I have an excel file that is connected to a dataset on one table and on another table I have a pivot table from that data. What I would like to know is how do I use DOMO to schedule that file to refresh the data and refresh the pivot table and then send it as an attachment to a user. Is that possible?
-
Deployed Excel sheet with add-in is getting an error
I've deployed an excel sheet with the Domo excel 365 add-in and the user trying to use it gets this error: This document has no imported contents It won't refresh the data. It works fine on my system. Thanks for the help.
-
*.xlsx issue after Workbench update
Following the Domo Workbench update to the latest version (5.2.8606.30751), I've encountered a problem where all my configured jobs are no longer functioning, displaying the same error message. The error happens when the Transport Type is ‘Domo SharePoint Data Provider’. All jobs are affected. All files are *.xlsx and I…
-
Dashboard Table using previous day values in calculation
Hi, I need to create a Dashboard that calculates oil usage for Engines. Below is the excel table with calculation I need to recreate in Domo. Basically need to take the tank level and oil added to day tank and engine from day before and subtract today's tank level to get daily usage. Also sometimes there wont always be a…
-
Scheduled Report - Excel Attachement
Allow scheduled reports to attach the data in excel format rather than csv. CSV files don't keep special characters in the data, so accented characters are messed up in the CSV.
-
Issues with Average Function
I have detailed biweekly pay data where I am looking for the average hours worked in every region per week (using a basic calculated field). This functioned well for 6 months but became an issue at the start of the year. Rather than finding my typical averages, suddenly the data is showing me trillions of hours in every…
-
Display estimated file size next to export options
It would be convenient and helpful if Domo could display a file size, either accurate or estimated, next to the Export options of Excel/CSV.
-
Extracting Data from SharePoint Excel spreadsheets
Hello everyone, I'm in the process of setting up financial reporting in Domo. Our FP&A team processes financial data and then stores it in two specific Excel sheets within our SharePoint. I'm looking for the most effective method to extract this data into Domo, creating a dataset that can automatically update with new…
-
Possible to Connect Domo Card within Excel?
I presently use the function of connecting data sets within excel. However, is there a way to connect an existing card to excel? I have a large data set that will take awhile to refresh in excel. The only solution I've seen is to create a modified data set using filter in an ETL.
-
Workbench 5 error message when uploading local Excel file...
Attempting to create a job uploading a local excel file using Workbench 5. Getting the error message depicted below… File looks clean to me. There are several formulas in the sheet returning #N/A errors. I've set the below error handling for this. Any ideas what is wrong with the excel file? (I've also tried to upload the…
-
DOMO Office Plug-In - Excel Filter
Hello, I am working with a client on importing a item list, into their Excel planning worksheet. When I get to the "Setup Filters and Select Columns" it won't let me enter in multiple selects for the "contains" value match. I tried to add another "selling season" filter but it gives me a duplicate filter message. Any help…
-
Which Connector to use to auto update excel files?
I have several excel files that automatically update daily with the same name. I want to get the data to Domo. I was using File Upload Connector, it doesn't update when the excel was updated. (I tried using File upload connect with an excel by deleting and adding several rows, clicked update through setting, but the…
-
Export to Excel: all available rows, regardless of "show only x rows"
Applicable especially to tables when to save space developers choose to show only a limited number of rows. However, it might be benefic to have the option to show all rows for exported files.
-
Exporting as .xlsx is exporting a 0 KB file when it worked for this card before?
We've got a card that is essentially a transposed Excel table. Employees have been able to export this card as .xlsx before with no issue. However, now Domo is exporting a 0 KB .xlsx file that when attempting to open, Excel says it is corrupted or an invalid file format. I can export the dataset powering the card just…
-
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…
-
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…
-
Excel Export Noitce/Warning
When a user goes to export a table type card, it would be helpful if there was a notice or warning when selecting the excel option informing the user that there is a ~1 million cell export limitation and to consider using CSV. This limitation is not found in the card detail view and may be missed by users. By adding the…
-
Export Dashboard as Multiple Excel Files
We have a dashboard that has 4 different tables and we want to schedule a report to send these as either 4 different Excel files or 1 file with different tabs for each table. We're going to send these reports to people outside of our Domo instance, so the Excel file is a must. Is something like this possible? If not, is…
-
Warnings for Exports w/ .xlsx that are over 100,000 lines is Gone - please reimplement
For the first 3 years at Domo there has been a warning about exports over 100,000 lines for .xlsx saying "there are possibly missing lines of data as you have reached the max data exported via .xlsx." The issues for us here is that people are going to be working with large data sets and then never know that data is…
-
I have two files as .xlsb in my shared google drive folder,
I wish to upload specific sheets of these two .xlsb files in DOMO, how to proceed?
-
Difference between excel plugin and excel addin.
When using the excel add from the excel windows store the domo content would disconnect and I would have to reconnect to the domo database to refresh it. Will the plugin provide a better experience? vs