-
Custom Connector - Parse a json object
Hi, I'll start this by saying that I don't know javascript at all, but I really want to figure out how to create a custom connector. So I was messing around and was able to get some data using the following partial script. What I want to do is to set the "resources" object of the response as a variable so that I can then…
-
Date Parameters like Tableau in Domo
https://kb.tableau.com/articles/howto/creating-a-filter-for-start-and-end-dates-parameters Above is how I would set a modifiable date parameter in Tableau. How can I do this in DOMO? Thanks
-
How do you allow some one without an account view cards in Domo?
Is there some way to allow someon to view cards you've built in Domo without having to set up an account for them? I know you can share slide shows or single PPTs of the cards, but we would be interested in sharing our reports occasionally with people where it doesn't make sense to give them account if we only want to give…
-
Google Maps in DOMO Cards
Does anyone know how I can link or display a google map in a card? The idea here is to show some properties on a google map. I saw one during a DOMOPALOOZA session and it looked really impressive. Any help would be appreciated. Thanks!
-
Can Domo connect to NetSuite SDN development account?
We tried to connector our Domo account with one of our NetSuite SDN development account. There are Production and Sandbox environments in Domo can allow to select when set up the connection account. I tested to set up the connection account in Domo by selecting Sandbox and run a dataset but received the error to indicate…
-
Workbench 4.5 Error: Object reference not set to an instance of an object
I am running Workbench 4.5 and when I migrated my Workbench 2.0 jobs I noticed that some were left out. When try to import them into Workbench 4.5 one by one I get this error: "Object reference not set to an instance of an object." Has anyone else experienced this error and does anyone know what's causing it?
-
%change Year over Year
Hi all, I am trying to make a card where I will have bars for total premium by year, and one line which will show % change betwen years (current to previous, previous to two years ago etc.). Do you have any advice how to do it, I tried to find solution on Dojo and Domo support but they point me to PoP knowledge base page.…
-
Uploading new data to Domo graph
Hi, What is the easiest way to update data from Excel into Domo without recreating the entire visualization from scratch? Or is it best to use Workbench to accomplish the said task?
-
Learning about Data Aggregators and Audience Data Monetization
Hello! I own a company which gathers demographic based consumer data regarding price perception of perishable foods and demand for perishable foods. I am very intrigued by the possibility of monetizing this data and I would greatly appreciate guidance with learning more about the subject. If you have any resources on the…
-
Incremental Serach Using Domo User API's
Is there any API's for incremental search (or) greater than filter is available for last modified attribute in DOMO rest API's..??? If so please let me know. Thanks in advance.
-
How to Make All Workbench Jobs Visible Across Machines
Here is my situation: My team uses Alteryx for our ETL, and at the end of several Alteryx workflows we are kicking off a Domo Workbench job via command line which requires a Domo Workbench Job ID. This works fine. However, when we promote from our Dev to QA to Prod environments, Domo Workbench only shows the jobs that were…
-
Facebook Connector Error
For some reason, I can't get the pre-built Facebook insights page to connect to our page. I'm an admin on the Facebook page. Whenever I go through the process, it just gives me the "error connecting" message. Any ideas on what might be going on here?
-
How to add aggregate function (COUNT (), COUNT DISTINCT ()) in filter
I have created a calculated field which will give COUNT () values. When i try to add that in filter, it is saying ' Aggregations are not supported in filters.' . But i want to filter data based on this value.
-
Beast Mode HTML Filter Value
I am trying to accomplish something that I feel should be very easy to do but can't figure out how to do it in Domo. What I am trying to do is add a link, field or button that has a more reader friendly name such as "View More" or "Drill Down Deeper" but the value / filter value is let's say for example, a date.…
-
Case Function with ranges in beast mode
Anyone know why this is failing? (CASE when `score`<=.2 then '2 or less' when `score`>.2 and <=.5 then '2 to 5' when `score` >.5 and <=.7 then '5 to 7' when `score` >.7 and <=.8 then '7 to 8' when `score` >.8 and <=.9 then '8 to 9' when `score` >.9 and <=.99 then 'Over 9' else 'other' end)
-
Table alerting me on NULL result
I have a table that gets updated twice a day. The most recent row is checked. If there are initials it's fine, but if there is nothing an alert via email is sent out. How do I find out if the cell is NULL to send my alert?
-
Can you create a card to share a video that you have created?
Looking to see if there is a way to feature a video within a card on a page?
-
How to cast as datetime in Domo workbench?
I need to add a date field to a job in workbench where the date is static, but not the current date. I have been attempting to create a calculated transform and expected to do something similar to: to_date('05/23/2018') or cast('2018-05-23' as datetime) Neither of those are available functions, however, and I don't see…
-
How to properly format Canadian provinces for map?
We used to use a column with the full province/territory name for the Canada map. It seems that with a recent Domo update, our data no longer fills any region of the map. What is the proper way to format the "Province/FSA Name" column? Does this column only accept the two letter code for each province rather than the full…
-
Close Rate By Stage %
Hey guys, We are wanting to analyze what our close ratios look like (%) from a certain stage to closing. For example, we have 5 stages in our sales cycle and we want to see "if we put a deal into the 1st stage of the sales cycle, what percentage of those deals do we close?" and another example "if we get them to the final…
-
Visualizing Tasks Done per Work Hour
Hey Dojo! I am having a hard time creating a dataset to allow me to visualize tasks done per work hour by an employee. The problem is I have two datasets to start with (tasks and daily schedule) which only have a single commonality being date. The tasks dataset creates a new row for each task done in our system which could…
-
Google Analytics tagging
Is it possible to add google analytics tags to our domo instance?
-
setting data label problem
Hi, When I add total label for my chart, i met a strange situation, some of my charts work but some don't, I've also tried with macro but still not working, did anybody met the same problem? Thank you~
-
How to add Month/Year Page Filter
I have a page with about 20 cards all showing data from one huge dataset. Each card shows the corresponding data from one field along with the data in that field for two months back (so like it would show 60 for July, 40 for June and 50 for May... basically I chose to view the ‘Last 3 Months’) What I would love to do is…
-
Beast Mode YTD % Change YoY
Hello, I'm trying to provide YTD % change vs. prev. year but I can't seem to pull a value from this. Any help is appreciated! (CASE WHEN TRIM(YEAR(`Date`))=YEAR(CURDATE()) then sum(`Online`) else 0 End) / (CASE WHEN TRIM(YEAR(`Date`))=Year(ADDDATE(CURDATE(), interval -1 year)) then sum(`Online`) else 0 End)
-
Bar Chart with Aggregate Line Trouble
I would like some advice since I am struggling to build the following in a card. I have a dataset structured like this: I'd like to produce a chart like the following: * Bars: each value where Record_Type = "A" * Flat Median line of only Record_Type = "B" records I would restructure and precalculate median in a dataflow…
-
Beastmode for HTML Stock Price Data
I'm looking for a couple of ways to create a card to provide up to date Stock price one way, i thought was to create a card and use HTML to pull the correct data? Any idea how this could be done?
-
Get First of Month in ETL
I'm creating an ETL flow that aggregates data by month. Is there a way to roll up my date field to just the first day of that month? I can extract the Month and the Year separately, but I need a result field that combines them back into a single 'First Day of the Month' field. I.e. RegistrationDate = July 3 2018, First Day…
-
I get the following error on most of my cards now "An invalid column was specified in your request"
Someone made a change to the data I believe. Is there any way to get more detail from this error - like which column it is. I am having a hard time finding the column it is referring to Thanks
-
Getting dataset error: WWorkbench DataSet Job is not allowed to dynamically change schemas. Help!
When trying to refresh a dataset that has not loaded in 24 days, I am getting an error stating: "Workbench DataSet Job (insertcompanynamehere.domo.com:6 (sqlSalesBI_uvwReportTwoYear) is not allowed to dynamically change schemas." How do I resolve this?