-
Centro connector All Brand Stats report date range
What is the date range on the All Brand Stats report from the Centro connector?
-
Domo to Trello authentication
I have created several datasets using the Trello Connector, and set them to append daily. They worked well for three days, but now the updates are all failing with the message, "Failed to authenticate. Refresh your credentials and try again." It would seem that the Domo to Trello authentication is failing, but I don't know…
-
File name SFTP upload
Under the SFTP setting WOULD YOU LIKE TO ENTER A FILE NAME TO SEARCH FOR OR SELECT A FILE TO RETRIEVE EVERY TIME. * ENTER FILE NAME Is it possible to set a file name to match two parts of the file name, for example FZG_Monthly_Calls_30062018_20019691_2263042_SIP_V3.txt.t is the full file name, but I want to search based on…
-
DOMO is ready but total_actions is not valid for fields param
Hi, Facebook Engagement Reports and Custom Insights Reports are now giving me this error when I run them: DOMO is ready but total_actions is not valid for fields param. Has anyone had this happen lately or have any ideas of how to fix it?
-
How to create SparkLines in DOMO?
Hi Folks, I have been trying to create sparklines in DOMO with no success. Is there a documentation available on the criteria or parameters that are prerequisite to have a sparkline I am able to get the values over a time period, but unable to show the comparison of current month value vs previous month Thanks in Advance
-
Does a dataflow get rerun if its input source gets updated while the dataflow is running?
I have a dataflow that has 2 input sources, and have configured it to run when either of the input sources get updated. If one of the dataflow's input sources gets updated while the dataflow is running, will that immediately trigger a rerun of the dataflow? If it doesn't immediately trigger it, then will it at least…
-
Has anyone figured out how to hid the "powered by Domo" at the bottom of embedded cards
We are embedding small cards into an internal site. The current lay-out is a 3x3 of cards. The "powered by Domo" both takes up a lot of realestate in each card AND looks silly when you see in nine times on the same page. It loks basically like the following (imagine visualizations and card titles as those have been…
-
Re: Social Media Reporting
We started with the quick start templates ourselves (great for getting ideas). After linking them up, we collaborated with our Marketing department to see what was of interest and eventually built some consolidated views around the metrics of interest to them.
-
Beast Mode: Returning the name of the month for all values...syntax error
Hi All, I am trying to make my date value state 'January' instead of '1'. I've been trying to use the MONTHNAME formula in beast mode but it won't let me complete it due to a syntax error. This is what I am typing in as the function - MONTHNAME('DateCol') Please see the highlighted portion of my attached screenshot for a…
-
Why does css code display incorrectly on an Android phone when placed within SQL code?
I placed css code within a SQL statement. It appears fine on a desktop browser, but not on an Android phone. The css code appears, but not the styling it's supposed to render. In this case, the text is supposed to be orange in colour.
-
can't graph by month
Why does the graph by option (day, month, year, etc) not always available? It just says none and cannot be changed. I'm using a date dimension in my X axis (YYYY-MM-DD) and numeric in my Y axis. What am I missing? I've never had this issue before.
-
Card Email Alert Content: Is it possible to Include list of Values from DataSet in Email Body?
Hi, Is there a way to create an Email Alert from a Card (e.g: Table) which includes the values of a particular column in a list inside the email body? For example, if the Table looks like this: ID Sites Score 1Site-412Site-623Site-714Site-91 I need the Email body to include the Sites in a list, e.g: "... The following Site…
-
Beast Mode Question for Distinct Count
Hello Beast Mode experts, I have a web activity dataset with IP_Address and Session_ID columns The relation between the columns is: possible one or more Session_IDs per one IP_Address When there is one Session_ID per one IP_Address then I count One Time Visit When there is more than one Session_IDs per one IP_Address then…
-
Problem with Facebooks Ads Connectors
Running into a problem with the Facebook ads connector and getting this error message for the past 4-5 days now. DOMO is ready but total_actions, total_unique_actions are not valid for fields param Any one else facing this and knows the fix that DOMO may have come out with?
-
YoY Variance: Trouble Excluding When Most Recent Week's Data is Absent
I've built a YoY variance chart for sell-out sales but problem is I'm using CURDATE for the most recent week and it's showing -100% until I upload the most recent sales data. I've proposed the below but it's coming up with an error message. Any help is appreciated! (CASE when (`Sales Week` like '%2018%' then…
-
How to count rows without returning all the rows in a dataset
I can call /data/v1/alias and this wil give me the metadata for the dataset as well as all the rows. If the dataset is big, this can take some time and sometime never return. So how can I just return the number of rows in a dataset. The column name is not always the same, for the dataset can be changed out. Is there a…
-
Drill path filters
When drilling down to the next level in a card, it appears the filters are being removed. For example, I have a card that shows comparative periods, YTD. When I click on 2018, I have a table card that shows information YTD for 2018 (no additional information exists). However, when I click on 2017, I get full year 2017. The…
-
Converting String YYYYMM to Date in Magic ETL
Hello, I have a DataSet that returns a column with a month as a string in format "YYYYMM" for example, April 2018 would be "201804" How do i convert this column to a valid Date column in Magic ETL???
-
Mass / bulk change data sets in dataflows
Hello, I have a dataset I replace every month. This one dataset is curently connected to many dataflows. So I have to update each workflow every month with the new dataset. Can I bulk change a dataset in many workflows at one time?
-
Is there a beastmode formula that can calculate the month to date line rate for everyday?
We are wanting to show the MtD line rate everyday of the month cumulatively growing like in the example that would be in excel.
-
Is there a way to get a list of cards linked to a dataset?
Hello, I have a dataset that has had some values and fields change and I need a way to see a list of all the cards that are linked to that dataset so I can go in and make adjustments to those cards. I know I can go to the dataset and see a visual representation of the cards that are linked but I"m hoping there is a way to…
-
Domo Connector - Oauth2.0 question
So I'm building a connector using the developer IDE, but I just can't seem to get the authentication script working with the 'httprequest' library (I believe it's domo built-in?) The connector will serve to pull data from my API and the API uses Oauth2.0. However, I'm having trouble getting a token through domo, but I can…
-
Difference since last month
Hi I'm trying to recreate a simple graph that I have in Tableau in order understand the capabilities of Domo. It's a bar/line graph combo. The line graph is just a plot of the input data but then the bar graph plots the increase from the previous month. In Tableau this can be created in 5 seconds with a quick table…
-
anyone pulling statistics from STatCan (Canada Statistics) ?
They have some APIs but I cannot get them to work with Domo... I am hoping someone else has already invented the wheel. https://www.statcan.gc.ca/eng/developers
-
Domo with Vue is not working
Hi Domo Team, We have follow the steps given from https://developer.domo.com/docs/dev-studio-samples/starter-kits#Vue%20CLI for integration with Vue with Domo but when we try to publish it return a blank page. it we just proceed "npm run dev" then the vue starter page is loaded successful locally. However if we run "domo…
-
Unable to load this DataSet
I get the error message "Unable to load this DataSet" when trying to select an input dataset in a MySQL DataFlow. Anyone else encounter this issue?
-
Is it possible to calculate Mode in a Beast Mode?
I've got a histogram card that is showing unit costs for items, and I want to display the most commonly applied cost (Mode) in the summary number. How would this be accomplised in a beast mode? Definition: Mode is the value that occurs most frequently in a given set of data. by the way... try searching for "Mode" in the…
-
Adjusting "Tomorrow's" date if tomorrow is a holiday
I have a dataset we can call 'jobs' which has one row for each job on our calendar. Row has a column that says if the job is occuring on a holiday or not. I want to filter on the individual card levels based on if there is a holiday tomorrow, 2 days from now, 3 days from now, etc. Job # | JobDate | Holiday 1 | 9/3/18 |…
-
Trailing Twelve Month Average using month number 1-24
I'm looking for some assitance. I'm trying to average totals over the previous 12 months, and the only field I can use to delimit the time is month # 1-24. Has anyone run into this before?
-
Best strategy for appending data from multiple sites to one 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.…