-
Datafusion Experiences and Limitations?
I'm trying to find ways to optimize the performance of my data flows and one thing I've been thinking about is leveraging datafusions to connect data. Basically I have a base data set from our admin that adds a new day of data each day, about 65k rows of data per day. So after 15 months of data (beginning of 2017) we're at…
-
Multiplication with a constant value returning incorrect numbers
I am multipling some columns in the table with *1000 as there is a need to convert 1000s to Millions on our business end. For eg. 222,000 is multiplied by 1000. I expect a result of 222,000,000. But I don't get the expected result. I see an increased number. Has someone seen this issue before? I am using the Calculator…
-
Forcing a zero or null value on a grouped bar chart to show the series data
Is there a way to force the series when the value in a grouped bar chart is zero or null?
-
How do i install a paid app as part of my company's instance of DOMO?
My company has a paid instance of DOMO, and i just wanted to try the "3 step predictive" app (which is listed as paid). i can add the app using "try it," but don't see a way to connect to my own data...can you help? i've sent a note to app@DOMO.com for support...but there has to be an easier
-
redshift transform year_month
I am trying to do some transforms within a Redshift Data Flow where I need the year and month from a date field in the form of YYYYMM so I can do some math with it. I thought I could use the extract(year_month from date) function, but I get the following error: The database reported a syntax error. [Amazon](500310) Invalid…
-
How to make a custom connector for the platform using SOAP API?
I am trying to build a custom connector for the platform 'ConfirmIt'. However, it uses SOAP API for data access. Can anyone please tell me how can I build a custom connector or share a link or documentation which could help me for the same?
-
Can I create a new widget to use in Design Studio?
I'd like to create a custom widget and use it in the Domo App Design Studio. Specifically, I want something that works exactly like one of the map widgets, with different regions shaded more or less according to the data, but where I can draw arbitrary boundaries for the sections. Is there any way to do this?
-
Versioning of connectors
Hi Domo Team, I'm currently building a Custom Connector. The online IDE you provide is great to have a quick running connector. However, is there a way for me to store the code in a Github repo of my organization and being able to push code (and publish new version of the component) via API ? Regards
-
How to erase the contents of an existing dataset without deleting it?
I'm quite new to Domo so my apologies in advance if I've missed something obvious... I'm using the Streaming API to create several datasets and pushing data to them from our internal systems. All these datasets use the "APPEND" option as we will incrementally push transactions and other data to these datasets over time.…
-
Is your Workbench GUI broken?
I opened up Workbench this morning and was welcomed with an update message. Unfortunately, after closing the update message I was taken to a Workbench window that lists all of my jobs, but I don't have the tree view on the left nor do I have the output/preview panels on the bottom. When I select one of my jobs, again,…
-
Beast Mode Calculation for cutting off the last months
Hi all, I have a question on how to create basically a Beast mode tyle filter that will cut off the last 3 months. my datecolumn is in the MM/DD/YYYY format (4/26/2018). So I would like to take the most recently closed month (end of March) and subtract it by 3 months to only report data up to 12/31/2017. Thanks for your…
-
Workbench 4.5 Error: Object reference not set to an instance of an object
I'm getting this issues when a do a preview on a new dataset. I'm trying to connect to SAP BW system via ODBC connection. The connection is successful and Validate configuration turns green. But when I'm trying to extract data from a DSO is where I'm having this issue. I'm more of SAP BW guy than a DOMO one. Any pointers…
-
How can I change the font size of data labels on a funnel chart?
I want to increase the data label size to make it more visible, but I don't see any font settings in either the Data Label Settings or General properties.
-
Beast Mode SUM Aggregation Workaround
I'm trying to structure a basic formula in Beastmode to calculate the total sum of a sales figure within a time range and then apply a multiplcation ONLY if it's positive. Dataset example (daily sales forecast): 1/1/2016 - $10 1/2/2016 - $-30 1/3/2016 - $40 Beast mode example: WHEN SUM(Sales forecast) > 0 then SUM(Sales…
-
Data Integrity Questions
* Domo received data from other systems. The data in ERP system and financial system can be drilled down to original record and audit trial to do data validation. Data in DOMO is from report level and have different integrations and manipulations to change the appearance of datasets and cards. What options in DOMO can…
-
Is there a way to perform a countifs-like function in Beastmode?
Basically, I have a dataset that is appended with new data regularly. I am trying to see how many accounts are associated with date a that are no longer showing up in the most recent (date b) appended data. I can write a meastmode variable that can show what lines qualify as date data a and date data b, and I can figure…
-
I have two labels for the data in my card's legend. How can I change the names?
I have no idea how to modify the labels. Thanks
-
Quickbooks job taking way too long
Hello, I have just recently gotten Workbench connected to our Quickbooks server on premise. Last night I attempted a test run using the General Details - General Ledger report with the date range from 3/13 o 3/20. The run started at 10pm PST. I checked on it at 12PM and say that it was in the same state as when it started:…
-
Connecting To Quickbooks Hosted on a Remote Computer
My Quickbooks account is hosted on a remote computer. It is not Quickbooks online. I must log into that remote connection in order to access my files. Can I make a connection to the data file?
-
Adding Conditional Colors To Single Bar Chart
I've built a single bar chart to graph the percentage of quota each of the agents on my team has reached. I'd really like to set it up so that when an agent's percentage passes 100% the bar turns green. Is this possible to do with a Beast Mode calculation or some other option I'm missing?
-
Gamification Apps
Has anyone found any apps that assist with sales gamification?
-
Suggestion for how to handle not having dynamic queries
I'm looking to see if anyone has run into a similar issue and to see what you might have done to combat it. Dataset 1: Information regarding a file running through a system (FileId, date process, type, file name, etc) Dataset 2: Information regarding any errors that occured during processing of the above information…
-
Error 429 After upgrade
After the update today I am having issues updating my data sets. I keep getting error 429 (To many Request). Is there anything I can do to fix this? thanks
-
How to Add Average Line in a Symbol+Grouped Bar Chart
Hi, I am trying to add an average line for the "applies" bar in this Symbol+Grouped Bar chart. Do I need to use Beast Mode for this? Thank you so much! Sincerely, Daniel
-
Twitter CPC
Does anyone know how to get the Cost Per Click from Twitter Ads?
-
Combining filed data
Hi, How do I combine data from the same field on different rows into one? To make it simple, lets say there are two columns. Data Source: Column 1=ID Column 2=deployed asset There could be different rows with the same ID but unique deployed asset How can I combine the two deployed asset fields into one and so I am left…
-
Hubspot "choice of fields" connector - multiple rows and extra fields appear
I'm hoping to pull in a selection of fields for all of my Hubspot contacts - for example, some standard fields like email, user ID as well as some custom hubspot fields like "opted out of marketing" or "completed onboarding sequence". I've configured the Hubspot > "All Contacts with Choice of Fields" connector and selected…
-
has anyone found it necessary to create an administrator user?
Has anyone found it necessary to create an administrator user? The subject was mentioned in one or two Domopalooza 2018 sessions and I'd like to learn more. There were maintenance issues/concerns with ownership of datasets, flows and cards when owners left the company or group. Once a dataset/flow/card was productionized…
-
azure data connector available to domo?
I'm investigating using Azure for data warehouse purposes. But I don't see any data connectors available for Azure SQL sources. Am I missing something?
-
Need a dataset - Global Company Headcounts
Hello Community! I need to do some research related to company headcount global footprints. I was wondering if anyone in the community knows of a source for that data. A few years ago, a team pulled it together manually from Forbes, but I'm sure there is a dataset somewhere that contains this information. Does anyone know…