-
Generating cards via API
Is it possible for me to create a set of cards using the API rather than doing it manually? I have a bunch of datasets and would like to generate the same types of card for each, but put them into different collections. This would be tedious to do in Domo, but a script could make the task substantially easier. Does the API…
-
Card Label Calculation
Hello, is there a way to add a calculation in the card label setting? if for ex I want ti show (Current Value / Next Value) Thank you
-
Play mp4 in Safari
I am trying to play an mp4 file that is located in a project folder. In Chrome it works perfectly, but in Safari it does not. Is it possible to play mp4 on iOs? Thanks in advanced
-
Bars won't show in Gantt chart
I build a card in Domo for a Gantt chart (to show product roadmap). The bars where showing (bars that show the timeline of a feature), but then I refreshed the data set and the bars disappeared. Any ideas?
-
Gzip data in custom connector
I'm working on pulling data from an api where I will be downloading a gzipped file. Before I get too far into trying to build a Custom Connector for it, is it going to be possible to process that gzipped downloaded data in the "Data processing script"?
-
Cannot Perform mySQL Inner Join
Hi I'm trying to make a simple Inner Join but the ETL does not produce data for some reason and my mySQL does not have the correct syntax. I've tried a combination of backticks and table.column format anfd nothing seems to work correctly. Can someone take a look please? SELECT * FROM `elevate_seats_june_28_2018` INNER JOIN…
-
Calculating Percentage based on multiple dates; calculations based on date selection
Is there a function or variable(s) that provide the value of the selected date range (i.e. the “from” and “to” of the DOMO Between fields? I would like to select employees who were active during a selected date range. If, for example, the date range was Oct. 13, 2017 - Jan 7, 2018, then all employees who are not terminated…
-
Case statement within a Range Statement
Hello all - I'm trying to calculate a value through beastmode from survey data and then use that calculation to provide a stage name of Novice, Transitional and Expert. Since I cannot reference a beastmode within a beastmode, I used the calculation in every case statement and had the sum categorized as a stage name. It…
-
DataSet API: APPEND failure behavior?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
DataSet API versus Stream API
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
Can % Change Be Computed Using a Beastmode?
[see attached image] Suppose I have this two column dataset: one column has the date and one has a quantity. What I need is to take a quanitity, subtract the quantity corresponding to the month before, and then divide that difference by the quantity corresponding to the month before. This is the (new-old/old) way to…
-
How can I change ownership of a Magic ETL DataFlow?
-
Does The Connector I'm Looking For Exist?
I have been shopping around for a connector on Domo but have not settled on the right one yet. The main purpose of this connector is to automate the rather arduous task of manually uploading ~25 financial spreadsheets to Domo each month. What I'm looking for: >Files can be saved locally and the connector is set up to…
-
Beastmode calculation error dividing
I'm trying to create a BeastMode that will give me 'average views per user'. (tool 1 views + tool 2 views) / total users = average views per user CONCAT ( (sum(`Tool 1 Views`)+Sum(`Tool 2 Views`) / (SUM(`Total Users`))) ,'Views') My issue is that it VALIDATES the code but then gives me the following error: "An issue has…
-
ORA-24374: define not done before fetch or execute and fetch error
I'm facing this error, when I try to create new job(in Replace Mode) in workbench. ORA-24374: define not done before fetch or execute and fetch error
-
Combined area and bar chart
Good day, I'm looking for a combined chart type, area and vertical stacked chart. Please let me know how can I achive this type of chart. see attached image as a reference. Thanks in advance for your advice Rene
-
PDP alert option missing
hi i am not able to see PDP alert option in my card though i have set it the dataset.Kindly help
-
Ryuu auth does not work
Hi, I am building a custom domo app and using ryuu to login. When trying to access my app in dev mode, i get this error: error: {status: 401, statusReason: "Unauthorized", path: "/domoapps/apps/v2/contexts", message: "Full authentication is required to access this resource"} In my CLI, domo login seem to work. How can I…
-
Expend table to create subcategories
Hello, How can I transform my table 1 to the format of table 2 ( as seen in the attached docment) I am doing it with magic ETL by maping values and then replacing it the first column , but it takes a lot of time! I hoped there would be a more efficient way of doing it. Any suggestions? Thank you!
-
Error: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for com
Getting Error in Workbench Job: Error: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in a Faulted state. I have never seen this error before. Has anyone come across this before? How can it be fixed? Regards,
-
Monthly Percent Change in Opportunities
I am trying to create a line+grouped bar card where date is set by month to show the % change in opportunities overall at the same times as the count of opportunities. The grouped bars measure how many opportnities were created by channel i.e., each bar represents how many opportunties came from digital, referrals, etc.…
-
How can I have Domostats include historical data as well
Currently my Domostats only imports data from the date I downloaded it. How can I change that so it includes data from the past as well?
-
"Batch_Last_Run_Date" Field MISSING
Hey folks, We need to creat a new card to show the last update date/time for our feedback survey pulling from Google Sheet. I think the best approach is to use "Batch_Last_Run_Date" field. When I try to build cards, it is unfortunate that this field is not shown up. I notice some datasets which pull from other source (ie.…
-
Beast Mode YoY Calculation Question
I am working on a beast mode calculation and need to mandate that the day of the year last year, based on my `Invoice Date' column, is less than or equals the day of the year this year. I can't think what I need to do to replace the "Last Year" and "This Year" with a working statement I can't use the Current date function…
-
DataSet API: Can multiple sites append to the same DataSet?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
DataSet API: UPSERT support?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
DataSet API: Compressed payloads?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
Table card Date Range set to "All Time" but is missing last 3 days
Hey everyone, First post here. I have a table card in domo and when I load it, it says the Date Range is "All Time". I don't have anything in here that I would want to filter by date-- I always want it to look at the entire data set. When I look closely at the "All Time" date range, it is consistantly a few days behind.…
-
Text in Table Shows as Linked
The text in my table seems to show as linked, even when it's not. I've narrowed it down to some connection with the size of the card. When I did tests, small cards weren't showing the text in the table as linked, but when the card was larger, the text in the table changed to show like it was linked, even though it isn't.…
-
前期比カードでのサマリーナンバー表示について
例えば、グラフタイプ「前期比」の「分散棒+折れ線グラフ」で前年同月比のカードを作成した場合、サマリーナンバーにトータルの前年比を表示することはできますか?