-
Fusion Data sets and Beast Mode Formulas
If all of the data inputs to a Fusion are changed (but dimension and metric names are identiflcal to previous datasets), will the beast mode formulas that sit on top of this Fusion remain intact?
-
カード作成リクエストの受け方
ダッシュボードやカードを作成する際の カードを作らない人からの要望は、どのように吸い上げられてますか? 要望がふんわりしていて、目的が定まってない状態で引き受けるのが多くなり もう少し効率的かつ効果的に、カード作成の要望を吸い出せたらと思っています。 リクエストシートなるものを用意していますが、ただこれやって欲しいと書かれるだけなので 何か良いアイデアがあったら教えてください。
-
Run Preview in magic ETL seems not quite there
If multiple data sets that are joined, for example, each one is sampled individually and the joint dataset is most likely empty Any adivce on how to use it better?
-
Custom Connector : Adding comma separated value in a column ?
Hi DOMO follks, Been creating a custom connector of recently and been working smooth uptil now. I have a set of columns which need to have an array of values separated by comma. How can i achieve this e.g. grid values should have "1,2,3,4,5" . I see there is a function datagrid.addCell( ) which can be tweaked ? Thanks
-
Converting “2.23333e+16” to decimal doesn’t work
Any advice on how to accomplish it?
-
Would expected that columns joined by would not remain duplicated in joint dataset
When joining on a column, I’d expect that column to appear only once in the output data set since the two are expected to be identical rather than appearing twice with 1 and 2 suffixes
-
Date Quick filter not always showing
As I have been building out cards with various date filters, I have noticed that sometimes Domo displays a date selector while often times it doesn't. What determines if this is shown. I am wanting to have this show up for most of my cards but it only is shown on a few. Thanks!
-
ETL to connect google analytics and SQL data with purchases
Hi all, Need your help in a following question: Our business is online retail. We track visits in google analytics and we track purchases on our site with accounting data stored in SQL server. What we want to see in domo is conversion rate: number of purchases per day / number of visitis per same day. First I think we need…
-
Where can I find this LinkedIn Ads connector? http://knowledge.domo.com?cid=linkedinads
I found this article in Knowledge Base about a LinkedIn Ads connector, however I don't see it listed under available connectors in Domo. Where can I find it? Was it removed? Knowledge Base: http://knowledge.domo.com?cid=linkedinads Thanks.
-
Need some guidance to count records in a dataset and then count of a subset
I have a dataset that is made up of a number of records or sales orders, there is a completed date and this would make up the first count which is easy count of SalesOrder Completed Date. The issue is the second subset, there is also a survey date which I want to count the number of surveys taken based on the survey date.…
-
Graph Display by Week calculates wrong numbers if add an annotation column on a specific date
Hello, I have a chart displaying conversion rates per day. In the section where any viewers can change the "graph by" setting, if this is changed to weekly then wierdly the graph displays the week that includes the annotated date twice in the x-axis and also calcualtes the weekly conversion wrong. This problem disappears…
-
Creating a grouped bar chart with multiple columns
Hi, Can someone help with how to create a grouped bar chart with values from 2different columns. Eg: dataset has 3 columns; date, apple sales, banana sales. How to show in a bar chart with date on x axis and apple sales & banana sales side by side in a grouped bar chart for each date? Thanks in advance!
-
SSO Changing Group Names Breaks PDP
Has anyone else noticed Domo SSO changing Group names when users authenticate? We have an AD Group named "SP_Webster" for example and Domo is now adding it to users as "SP_Webster1". This started for us yesterday and it is breaking ALL of our PDP-enabled cards.
-
YOY drill down problem
I have a yoy card with three years of data displayed by month. For the month of November, the card displays the correct paritial month comparitive amounts for Nov. 2017, compared with Nov 2016 and 2015. However, if I drill down on Nov. of 2016 or 2015, the detail contains the full month instead of just the partial month…
-
Percent comparison chart with more than 100%
I hope I explain this correctly. I am trying to get a stacked chart where my field 'Estimated Hours' = 100% and my 'Actual Hours' is a percentage of 'Estimated Hours'. The Estimated Hours field has different values across the chart so I didn't think they'd all be even at the top. I'd also like to show it where if the…
-
Changing color rules in box plot graphs
I notice that the color rules are grayed out for box plot. It would be nice to change the coloring of the box plot based on discrete values (e.g., affiliation, geography, etc.). Any plans to add this functionality to the box plot graph?
-
illustrator app hyper link to card
Is it possible to create an app using Adobe Illustrator that when publshed in Domo has a hyperlink to a particular card?
-
How to add a calculation to beast mode that involves uncollapsing columns into rows
I have a Data table with the Actual amounts for Accounts Receivables to which I have appended another table that has the budget amounts on a monthly basis. I created a sumo card to view the data in pivot format . I now need to add a calculation to the sumo card, but the calculation involves data that comes from the same…
-
Beast Mode: Percentage of Total Inventory - comparative gauge
I'm trying to build a comparative gauge to display the percentage of total inventory. * Attached is sample data * Here is a video I put together to explain Where this is tricky is keeping the total inventory value for the calculation. Can you help?
-
Is there a way to import org data or is it manual setup only?
I want to create and populate the org chart in Domo but I don't want to have to maintain this manually. Is there a way to automate this via connector or data source?
-
Is there anyway to see all the cards and drilldowns that won't load data because they have an issue?
We recently modified the name of a field because it was irrelevant. Now all the cards and drilldowns that used the old field name won't load and need to be updated to the new field name. Rather than going through and clicking every card and drilldown to check if it was using the field, is there a screen I can use that…
-
Create Beast Mode Calculated Field from sub-string in Placement separated by multiple delimiters
Hi, I need to select a substring from our Placement Names that returns the Creative Name that is nested within the Placement Name. The characters within the Placement Names and Creative Names vary, so I need MySQL code that works in BeastMode that concatenates all characters between the -3 underscore and the -2 underscore.…
-
Is there a way to access dataset info like history, status and error information through the API?
We have lots of complex datasets and would like to use the API to help manage them using Domo itself. I would like to make a card that mainly shows dataflows that have and error or are disabled, and if possible the error source message and any other information that is available. Is there a way to get this information from…
-
Salesforce Case Reports
I have several reports that are currently manually put together and I'd like to display them in Domo with regards to Case Open Date and Closure Date. the 2 dates I have are open and closed date along with the Case detail information. I need to aggregate the data to show this below. So here's what the current report looks…
-
Ad hoc "Fusions" in the card builder interface
Is it possible (or intended to be possible, if anyone might know) to build a card based on several datasources and specify the join in the card builder instead of building a fusion ETL per card? The benfit we see in that is that we have much less clutter in the data center
-
Drop a column in Magic ETL
Is it possible to transform a dataset and only specifiy ehich columns to drop, rather than thos to keep (negative rather than positive selection of columns to "keep")
-
How to create date series with beast mode
I'm trying to create a series of data: Same Day, 0-14 Days, 15-30 Days, 31-60 Days, etc I have 2 fields Created_Date and Closed_Date. If created_date = Closed_Date then "Same Day", if Closed_date - created_date < 14 days then 0-14 Days and so on. My beast mode looks like this below. I was trying some stuff but anything…
-
Using date dropdown to manipulate a card that aggregates using two different dates
case study: I want to create a card that for a given date range, it returns the number of orders taken and the number of orders completed. The dataset has one record per order, and there is a "order taken" date field and a "order completed" field. I could use SQL to create a dataflow that that creates one record per month…
-
Filter on Beastmode Case
I have successfully created my beastmode case to identify anything over my threshold of 1000. I now want to filter based on values that return a "YES". I'm aware that you cannot filter on beastmode aggregates, but what is the workaround to accomplish this?
-
Display percent variance as Summary Number while using Period-over-Period card
Has anyone come up with a way to display the variance shown on a period-over-period card as a field for the summary number? I've got a card which displays our attendance this year-to-date compared to last year-to-date. While the variance is displayed on the card, the CEO wants the variance also shown as a summary number.…