-
Wrong data on datasets after fetching from Box
I have uploaded csv file on Box and when I am creating dataset using Box connector, the file which it is fetching is a data but incorrect. How do I fix it? I have attached screenshot of actual data that is uploaded on box and another data that is showing from datasets after Box is connected to fetch data from file on Box.
-
Facebook Ads Conversion
Hello, I want to create a report showing conversions and conversions value of facebook ad campaigns. I can't find these metrics in the facebook ads connector. Does anyone know how to get that data into Domo? Thanks, Michelle
-
Breaking out a string
Hi, I have product information that is a string seperated by commas. I wanted to take the first line and convert it to the lines in bold and continue the pattern. How can I accomplish this: Style #Selling SeasonsM200B14BAR14B ,15D ,14C ,14D ,15A ,15B ,15C ,16A ,16B ,16C ,16D ,17A ,17B ,17C ,17D ,18A…
-
CSV file import via Python DOMO API SDK
Hello, I'm working to get an automated import of a .csv file. It is currently working using the "datasets.data_import_from_file" under the Datasets module in the DOMO SDK. The problem I've facing is that this import is performing a replace where I need an append operation. Is there an APPEND parameter I can add to make…
-
Workbench Logon failure
I'm seeing the following error when trying to run Workbench jobs: Logon failure: the user has not been granted the requested logon type at this computer Any ideas on how to resolve this would be appreciated.
-
Is there a way to get impressions from twitter (organic)?
I'm relatively new to Domo. I'm working with the Twitter cloud connector and am unable to replicate the data I can export directly from the Twitter Analytics UI. For instance, I haven't found where to ingest impressions or some of the underlying metrics that make up the twitter engagement metric (i.e. not just retweets and…
-
Impressions from NetBase
Is anyone connecting NetBase on DOMO? I tried to pull out the 'potential impressions ' shown on my NetBase, but my option on DOMO says 'impressions'. The number of impressions is about ten times less than potential impressions I found on NetBase, so I'm guessing does 'impressions' on DOMO means 'actual impressions'? If so,…
-
Add more than 2 bars to the Grouped&Stacked Bar Char
Hi Dojo, So I am constructing a Grouped & Stacked Bar Chart card and I need to have 3 bars (as opposed to the default 2). Any advice on how to do this? Is it not possible? Background: I have 3 values: * All In * Segment * =(All In) - (Segment) Ideally I'd have a Stacked bar for each of the 3 values. Any help would be…
-
Bug Update: Filtering on Null Values
Past May @SamEich posted a bug regarding Null values. Basically the filters you add to a Domo card are not able to filter on a null value. I ran into this problem several times and the bug still does not seem fixed. How could we know the status of this request and when it will be implemented? Should I contact Domo Support?…
-
Line Percent of Total Chart
I'm struggling trying to figure out if Domo can handle creating a line chart that calculates the percent of total for the value, then show those values as percentages on a line chart. I've been searching around forever and have tried using %_PERCENT_OF_TOTAL as a data value label, but the problem there is that doesn't…
-
How to create a cohort analysis?
Hey, I would like to recreate a cohort analysis (see screenshot of excel below). In the first column, we have the trailing past 30 days and in the first row the number of days that are added to the respective date until the customer is won. Is there a way to replicate this in domo?
-
Time zone (bug)havior summary and questions
I just stumbled across some issues in how Domo manages datetime values and have some questions. I've looked through the docs and the Dojo and see that my questions aren't rare. After reviewing a lot of materials, I'm still not clear about how to show charts in local time when you have users or facilities in different time…
-
Filter Rows in Magic ETL based on Text
I am using the Filter Rows aspect of Magic ETL and having trouble filtering if the text filed ins not one word. For example if I create a filter that says ColumnA equals TESTWORD - I get rows where the columns had the value TESTWORD. If I create a filter that tries to filter ColumnA equals TEST WORD - (space between test…
-
Data Labels Font Color
I have some bar/column graphs that I would like to apply data labels with white font, instead of the default text color, for better visibility. Is there any way to do this? Thanks! Jamie H.
-
SFTP Connector - Any way to read files from a specific folder?
Is there a way to bring in data from a specific folder via the SFTP connector? I set up an SFTP connection and I could only access files in the root directory. If this isn't possible, could someone recommend an alternative way to bring in this data? We do not have Workbench set up yet since we are relatively new to Domo…
-
Available work day
Hi! Is there a way to get available workdays onto a dataset? For us, that is basically M-F every week of the year regardless of holidays. The current field in here now called 'Date Worked' assumed the person entered a timesheet for that day. we want to capture the 'date worked' regardless of whether they did a timesheet…
-
hubspot dataset not running
I've added the HubSpot app but when I try to run the dataset, it runs for a few minutes then fails. Does anyone use this app have experience on how it works? If not where is a contact for support/help? Thanks!
-
Publishing a dashboard to a website
Hi there, Is it possible to publish a dashoard from our instance to a website? i.e embedding it so that it is still interactive. Thanks!
-
散布図で回帰直線が表示できます!
散布図で、縦軸(Y)と横軸(X)の関係を表す回帰直線を表示させることができるようになりました。 「チャートの設定」→「線形回帰線を表示」にチェックを入れると添付ファイルのように回帰直線が表示されます。 具体的な傾きや切片、精度(決定係数)などを知るためには、別のツールで計算する必要がありますが、明らかに相関関係が存在する場合などには、回帰直線を表示させることで、より関係性を明確に表現できると思います。
-
Warning: Not all the data is shown
Hi.. I have created drill down view in table format and it is not showing all data. How to enable all the data to be shown.Though there are only less than thousand records.. it is still showing the warning message "Warning: Not all the data is shown". Any solution for this?
-
How do I merge columns?
I am trying to get my columns to be consildated. I have duplicates after joining my data together. How am I suppose to do this?
-
DataFlow ETL to change column values based on values in another column
We recently discovered a data tracking issue that affects one of our datasets. The result is that the Revenue values have become meaningless after 24th April 2018. The other columns of data are ok and are still required. My aim is to change the all Revenue values to 0 when the date is greater than or equal to 24th April…
-
Need to calculate daily/monthly ratio. How to combine two date ranges in one card?
Hi all, I need to calculate a daily users / monthly users ratio, but I am stumped as to how to build the Beast Mode to indicate the following logic: "COUNT(DISTINCT `user id`) for every day and divide by COUNT(DISTINCT `user id`) for the whole month" This will be calculating this ratio over time. I don't know if this can…
-
Embed Cards
I am working on a Weekly Update for my team, it will include updates on how our section is performing. I am looking at using HTML for the update and Embed cards from Domo to show how we are performing. Problem I have is I have to manually enter login credentials for every card. How can I store my username and password so…
-
Domo Everywhere (White Label/Embed/Publish) - Best Practice Knowledge Share
With an ever increasing number of customers solving challenges and creating new business models with Domo Everywhere a place to discuss and share best practice might be helpful. This thread is intended for customers using Domo Everywhere to group together towards shared goals
-
Domo White Labeling (Customer Branding)
Apparently there may be one or two customer Domo instances out there that have had some sort of customer branding done to them. That said I can't seem to find too much about them. While I know Domo is currently exploring this option with the Domo Everywhere option, I am curious to know if anyone else is aware of any Domo…
-
Error in Workbench
I recieve the following error. has anyone seen this? C:\Users\a111661>"c:\program files\Domo\workbench\wb.exe" queue-job --server radioshack.domo.com --jobid 191 No connection to radioshack.domo.com I have not been able to find any entry in any logs related to this.
-
Unable to get Instagram Business app to connect
I'm not able to get the Instagram business app to connect. I have a valid Instagram business account that is connected to my facebook page. Whenever I try to connect to the Instagram business app in the app store a window for facebook opens up with an error message that says: "App Not Setup: This app is still in…
-
How do I escape single quotes/apostraphes in a Beast Mode?
Suppose I have Beast Mode the following syntax: CASE WHEN `lastName` = 'O'Sullivan' THEN ... The apostrophe in O'Sullivan breaks the Beast Mode. Is there a way to escape the character?
-
Removing filters from drill paths
Hello, Is there a way to remove filters from drill paths? For example, if I have a stacked bar by month and by business unit and I want to add a drill path that filters ONLY by business unit and not by business unit AND month? Thanks