-
Failed While Executing
I recently attempted to push some additonal transforms to an existing mysql dataflow to incorporate some brand-new data points. When I went to run the dataflow, I received the error message below: Failed while executingThe database reported a syntax error. Out of sort memory, consider increasing server sort buffer size Has…
-
Third Level menu on DOMO main Page
When will you deliver on your promise of a tree tier menu for pages?
-
How can I connect a csv file that is 1GB in size?
Hi All, Can anyone let me know how to connect a file with 1 GB size as I am facing an error: "Cant connect file with more than 256 MB size" I tried CSV connector and simple file upload but same error. Thanks, Kumar
-
% of total
How can I get the % of total value in a table card, like the below? Data will be in a similar format to below, although the users will be able to pick a Year and Week Number. SupplierPallets% of totalSupplier 1515.63%Supplier 226.25%Supplier 3618.75%Supplier 4928.13%Supplier 539.38%Supplier 6721.88% 32100.00%
-
Issue on adding new dataset using 'DataSet via Email' connector
Hi, I have 35 'DataSet via Email' datasets in my account already. But when I tried to add a new dataset using this connector, system said that the 35 existing datasets were through 'smtp' connector rather than 'DataSet via Email'. That means 37 datasets through the same connector are identified as using two connetors now.…
-
Result of Date functions do not align in Transform
I am getting the wrong date listed when I use CURRENT_DATE() in a transform and it is a causing my data to display incorrectly. Why does it show the date at Dec 7 when it was actually Dec 6 as the NOW() function shows? How do I fix this?
-
Setting Alerts - DoD
Hi, I created a chart, which shows me a KPI from yesterday, the day before yesterday and it´s variance (The data is broken at the moment, so results are completely wrong). Afterwards I created two alerts, which for test purposes only alerts when there is no change (which is not possible), One on "Most recent" and one on…
-
Beast Mode
Is there a way to take value from a column based on value in another column? I have a table, similar to the below, where I have forecasted and Actual figures for 2018 but only forecasted figures for 2019. I need to write something that if it see 2019 in the Year column then it takes the forecasted figure, but if its 2018…
-
Daylight Savings Fixed in Dataflow - Wrong when used in Card
I have a daylight savings issue where my "tranendtimes" are correct in the dataflow, however, when I use the field in a card it is off by an hour due to daylight savings time. What is the workaround for this?
-
Limit number of Rows in Bar Chart
I'm trying to do a stack rank of a set of users using a grouped bar chart, however in the general settings, I'm unable to figure out how to limit the maximum rows. I've done it in the past for a single bar chart but for a grouped bar chart, this doesn't seem easily doable. Thanks!
-
Is there a limit to the number of inputs on a Magic ETL dataflow?
Beginning to create a dataflow in ETL that will require 100+ inputs and don't want to continue if I am going to hit a limit at some point. Anyone know if there is an input limit? Thanks.
-
Percentage in Legend
IN a card, is there a way to put percentage in the Legend rather than the total? I know you get the percentage if you hover over the segments but it would be handy to see the percentage in some of the reports I am working on.
-
Best Practices for K-12 Education
Hello fellow educators! I'm interested in collborating with other K-12 districts on their uses of DOMO. Currently, we are using cards to highlight demographic and student performance data. Please reach out if you are interested in sharing ideas.
-
Domo Developer: How to resize the card size to fit the screen?
Hi, so I have successfully uploaded a simple app to Domo using the guidelines in Domo Developer site and adjusted the css margin and padding. But when I uploaded the app to Domo, the result looks like this: Can anyone tell me how do I adjust the card size, making it full screen or utilize the space of the grey area? Thanks!
-
Adding/subtracting dates
I am currently using a Date Operations and Calculation block in ETL to determine a "turnaround time" for maintenance orders, from initiation date to completion date. This works well via a Day of Year conversion and simple subtraction, however it's not the right solution since tickets that are open during a yearly rollover…
-
Calculating Column % based on Row value
In Income Statements is common to calculate a % based on a "Net Sales value" in a row, as follows. Statement Level 2Jan%Gross Sales$113,894,029117.9%Freight Revenue$00.0%Sales Returns-$427,9570.2%Cash Discounts-$2,587,6871.1%Rebates & Other-$14,254,6545.9%NET SALES$96,623,730100.0%Standard Cost-$161,325,16366.6%Standard…
-
Warning: Live updates cannot occur because this is not the only instance of Workbench running
Anyone ever get that message? I am having issues with the jobs running nightly after setting them up and wondered if this error was part of the root cause. Thanks!
-
Is anyone importing their Domo datasets into Power BI?
Is anyone currently importing/exporting data from Domo into Power BI to combine data? I recognize that this is the purpose of Domo, but I'm exploring ways of getting datasets that are currently in Domo into Power BI as a work around for sales data governance. I know in the June release Domo came out with Domo ODBC Data…
-
Vlookup/Related Function
Hello, I am working on a project that is combination of 3 excel coming from different servers. 1.Shall I define the data flow? if yes do we have vlookup functionality to combine the 3 excel report, do I need to define the mapping ? 2.Shall I upload the excel and then select the fields that I want from each excel What will…
-
ETL joining causes an output dataflow that is too big?
I am very new in using Domo, so hopefully I can explain my situation well. I have three datasets that have different column names and structures, even though each dataset has same columns too, like 'Employee Name' and 'Employee ID'. I tried to join them (using inner join) and run preview with 10k limit, but it showed the…
-
Running a Connector Dataset Programmatically - Full Authorization Required
Hi, I have a dataset created using the Amazon Redshfit Unload connector, created via the Domo Web Interface. I would like to call this programmatically via a POST request to the api. I am making a post request to: my Domo instance using OAuth 2.0. And I am recieving this response: { "status": 401, "statusReason":…
-
An issue with header row
I built a card in a table. It is basically a financial card and gives the predicted and actual amount for each GL account. And I made the hearder row visbible to calculate the sum of the predicted amount and actual amount in total on the top of the table. After I finished the card, i downloaded the dataset directly from…
-
0 record dataset update
Question: When a scheduled run of a dataset returns records, the dataset is updated. However, in subsequent runs when the resulting record count is 0, the dataset is not updated and the Last Run time stays as previous. How do I force Domo to make the dataset have 0 records which is the result of the last run and also…
-
Mr. Roboto Insights keeps opening
Sometime this week, the Insights tab keeps opening every time I open a card. I don't see any option to disable this. Any hlep?
-
JIRA Issues with multiple 'Sprints' only showing one
I have an issue with the import of JIRA data. When importing issues with fields that contain multiple values (separated by comma), DOMO only reads one value - I think it only reads the last known value. Especially when trying to create 'sprint reports' it is a problem because some issues get included in multiple sprints.…
-
Lost all my dataset jobs
Workbench suddenly, and seemingly for no reason, lost all my dataset jobs - is there any way of restoring them?
-
Has anybody used the ADP connector? Is it able to reach custom reports?
We are looking to change payroll companies but need to make sure we will be able to access all data though the Domo ADP connector. When the connection is made; do you have access to any custom report and canned reports from the system? or are there limitations? The answer is important to us in choosing a new Payroll…
-
Calculate duration for data fusions?
Is there a log to show how long it takes for a data fusion to complete?
-
How do I translate this Tableau code to Domo?
Hi, So I need to translate code from Tableau to Domo and since I am very new to Domo, I will need your help to translate this Tableau code that looks like this: { FIXED [Employee ID],[Area Code],[Supervisor Code],[Day of Date]: IF SUM([Commission A])>SUM([New Base Salary Current]) AND SUM([Commission A])<SUM([Second Base…
-
How do I hard code values in a beast mode
Here is my beastmode. But when I pull it into a card it shows different amounts and it doesn't sum it correctly either. Is there something specific i need to do to make sure it knows it's a value? SUM((CASE WHEN `premiumtype` = 'Test' AND `planeventtype` = 'Full Season' THEN 18000000 WHEN `premiumtype` = 'Test1' AND…