-
May 2018 update includes zip code maps. Has anyone actually figured out how this works?
The May 2018 update release makes mention of zip code maps. Our organziation has been clammoring for these since we got Domo a year ago. So upon reading the release notes for the May 2018 update, and seeing that zip code maps were finally a thing, there was much rejoicing to be had in our office. That was until we tried to…
-
Current release version of DOMO
what is the current stable release of DOMO?
-
Redshift Data flow runtime increased
I added a new dataset as input to a Redshift data flow. After I made this change, the dataflow runtime went from 10 minutes on average to 40 minutes. How can I shorten the runtime so it's back to an avg of 10 minutes?
-
Using SQL Query to create cards.
How to create cards using Oracle SQL query i.e. I have a Oracle SQL query which I can use to create the card. Where I need to embed the SQL to create the visualization using that?
-
What additional Formulae are there for the Data Label Settings?
Hello Everyone! I am working on a funnel visualization, and we want to include counts, as well as totals in our data labels. Is there a formula to do that? I tried %_NAME $%_VALUE %_COUNT...But that didn't work. I believe I was told before that there were additional codes beyond the hints provided. Any thoughts?…
-
Data for 30 days
How can I get 30 days of data irespective of month through Beast Mode? it could be 20 days of April & 10 days of May.
-
Network Graph
Hi All, As someone built a custom app that include a network graph (nodes, arcs), (see image attached!)? If the answer is yes, would you be willing to share your solution? Otherwise, has somebody got an idea on how to solve it in Domo? Thank you Regards Marialisa
-
Reference to the row number in a beastmode
We are loading data from Domo exports into another system. We created a card that looks like our import file and simply export to Excel. The first set is 500,000 rows but must be uploaded in chunks of 20,000 rows each. I wanted to create a column that gave me a number incremented in chunks of 20,000. This was simple in…
-
Twitter engagement data
I'm trying to pull in a few of the standard Twitter performance metrics available natively (via Twitter Insights). Specifically, I'm looking to pull in metrics like Impressions, Retweets, Likes, URL clicks, etc. To my understanding, the current Domo connector (Twitter Advanced) does not offer this capability. Has anyone…
-
Case When
This is confusing to me. I am used to If, then statements. Could someone tell me the error when using this statement. The idea is when the discount level is 0 I want to divide it by 64, if it is not 0 then I want to divide by 24. This is what I have. CASE WHEN `Discount`=0 then `Quantity`/ 64 else `Quantity` / 24 Thanks!
-
Date Annotation - no longer working
We recently upgraded from trial to professional version, but we seem to have lost the new Date Annotation feature. Is this enabled on all instances? I can't find anything in the Dojo.
-
Comparative charts on a single card
Needs to create multiple charts in a single card for data comparison. Can we do that?
-
Calculation for Growth YOY
Hey! I need help figuring out a calculation for growth YOY. I have a dataflow that streams in total sales, which I created a bar graph for YOY comparison for each month. From my data set, I am pulling in from a third party, each line has a date and amount in sales. I want to see growth from Jan 2018 to Jan 2017 as well as…
-
Can you only assign tasks to a project that you're a team member of?
Basically the title of the post - can people only assign a task to a project if they're a team member of the project? This to me seems like an oversight because what if people who weren't assigned to the project sees an issue with a card and wants to assign it as a task to the project but aren't a team member? I was also…
-
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…
-
How do I calculate current year WTD sales and previous year WTD sales?
I'm trying to calculate this week's WTD sales through yesterday and compare it to the same WTD sales for last year. Our week starts on Monday and ends on Sunday and I can't quite get our numbers to tie to a check that I've built in Excel. Here is the formula I'm using for this year's WTD sales in Domo: SUM(CASE WHEN…
-
Is there any way to replace x-axis and y-axis (without changing Excel file)?
I would like to change X axis and Y axis on domo card. In case if ì want to keep the original format, is there anyway to swap X and Y on domo card visualization?
-
Can you use Alias mapping in the manfest.json file via the Data API calls?
I know I can access the use domo.get('/data/v1/sales') and access the sales alias in the manifest.json But I want to get the unique ID of the dataset for "sales" The only way I see you can do this is via the method above. but if I am using the APIData Access, then how can I get the Unique Id of the dataset . This alias…
-
how to download soybean prices from QUANDL (cloud API) into domo?
-
Creating a running percentage chart
Hi All I have a dataset, which is broken up into 4 populations (which is my series). I am trying to create a chart (or table) that shows the percentage of each population that had made their first purchase by a given day after signing up as a member (ie- % that bought for the first time by day one, then cumulative…
-
Record breaking month alerts for salespeople
I want to create a card to trigger an alert when people in my company have a "personal best" month. How is the best way to build a card so that I can get this alert for everyone? The only way I can figure out now is to build a separate card for each person but that's not sustainable when multiple metrics are tracked and…
-
Auto Convert .mht file to excel
I am trying to use the Domo Email Connector to grab a file contained in a link in the email. However the file is of type .mht and Domo does not recognize it because it is not actually an excel file. Does anyone have any suggestions?
-
Randomly Displaying a Field
I'm trying to solve for a problem and am not sure how to do it. Haven't been able to find anything about it and none of us can figure out how to hack it together. I'm looking to do the following: * Take a data set that has only text in it * Display a random row out of that data set in presentation mode on a TV The way that…
-
Is Creating Year over Year comparison in a table possible with Beast Mode?
I know that there are "period-over-period" charts, but I need to build a YOY comparison in table format for a financial project. Is this possible using Beast Mode calculations? I've attached a picture threw together in excel showing the desired layout of my DOMO card as well as a very simple example of my dataset. Please…
-
Is there any way to connect to an FTP/SFTP server in a custom connector?
I am building a custom connector, and the API call to get the data I need will not return the data over HTTP, but instead generates a csv file that is placed on an external SFTP server. I know JavaScript does not have functionality to work with SFTP, but as this is using the Nashorn engine, I believe it should…
-
Converting Seconds Into Minutes
Hello, I have a number column (not date) that I need to convert the number into hours, minutes, seconds (hh:mm:ss). I have now idea how. Example: I need 135 to display as 2:15 and not 2.25.
-
CTE not running for dataset self join
I am trying to combine a dataset with itself to calculate two flavors of one column. I could not figure out why it should npt work. I apreciate your help as I am new to mysql syntax WITH cte1 AS (SELECT `period`, `FY/Qtr`, Count(`contract number`) AS `Total`, `PFA Type` FROM cm_reports_dates Group by `period`, `FY/Qtr`,…
-
Graph showing by month, average condition for 16 different rooms.
I need to create a graph where I show, by month, the monthly average condition of each of 16 different rooms. Each room will have 4 to 5 values for every month (one per week) and I need to take the average of that for each room and show it on a stacked bar graph. Attached is what I got started, but the issue I am having is…
-
can you download a user list with access rights?
How can you see a list of all users with their emails, access rights, etc? Without this, how do I filter out all the domo people, etc? Thanks
-
How to do text mining
Hi, I would like to make the categorization of text data, such as twitter on Domo. Now, one way, we make the categorization by matching the keyword with DataFlow. Do you have any idea to categorize the text data ? or are you using text mining tool ?