-
Dataset does not display in overview tab in datacenter
I'm assuming this must be a broswer issue, that I can't see any data in the "overview" tab of a (dataflow) dataset in the datacenter. It does give me all other info, such as number of rows, etc... when I export to file it seems data is correct. However, the data does not dispaly in the browser from my laptop. If I try same…
-
Run Dataflow on specific rules
I have a dataflow that brings in 2 datasets and provides an output that does a reconciliation of them. The 2 datasets are updated daily but only change once a month - usually on different days. I would like to be able to only run this reconciliation dataflow when both datasets have changed to the next month. Is there way…
-
Use recursive dataflows to update datasets
We have 20 to 30 massive tables (+40 million rows) that need to be updated. I am wondering whether a recursive dataflow could be an alternative to update all these datasets. I have researched the option of recursive dataflows, but it seems to me that it is a two step process (first, add the input datasets to create an…
-
MTD,QTD,YTD Report - Reporting Year Different from Calendar Year
I am developing a data table showing Month to date , quarter to date, year to date Usage and Target in column and different segment in rows. My usage and target data is granular to daily detail. My challenge is that reporting year is different from calendar year, and I need to report YTD and QTD. Appreciate suggestions
-
I've done some analysis in Google Sheets I don't want to re-do. Can I just import just a few numbers
I'm trying to hook up the Google Sheets connection, but my Google Sheet isn't rows and columns, it's just a column of variable names and a value next to each one, which is a live formula. Is it possible to just connect that much? I tried transposing it so each variable was a column with one number underneath because I…
-
Tables doubled up in PPT export
Is anyone else having an issue with doubled up tables in PPT exports? This has only been since the update on Tues., and I was wondering if it's related to the update, or something on my end. Thanks!
-
How to filter dates for last activity for the last 2 weeks?
I'm looking to show leads that have not had activity for the last 2 weeks, but can't seem to filter it that way. HELP!!!
-
テキストボックスカードを作成した際のエラー表示に関して
上記、テキストボックスカードを作ったときの画面なのですが、 左上に「注:表示されていないデータもあります」とエラーが出ています。 こちらはWorkBenchでの取り込みエラーを確認するため、 DBに入っているレコードの最新の登録日を表示させています。 同じカードを作成しても、このエラーが出る場合と出ない場合があります。 これはなんのエラーなのでしょうか。 ご存知の方がいらっしゃいましたらご教授ください。
-
Combining 4 rows into 1 on a dataset
Hello, We use Google Analytics and I have pulled in data from 4 segments. The data in the table gives 4 rows per day with a column for the segments (there are 4) and another column for my other metric. I would like to combine the segment name and metric data to a column (ie...'segment name' as the column header with the…
-
Defining histogram bin value ranges
I am attempting to build a histogram. Rather than customising the number of bins and having the ranges in my value set automatically calculated dynamically by Domo, I want to define the range that each bin should cover. Anyone else out there found a way round this issue?
-
PPT template when exporting
Hello, is it possible to export a PPT with a given styling "skin" or "template"?
-
ETLの値マッパについて
ETLの値マッパで以下の編集をおこなっています。 ・やりたいこと URLが入っているカラムを /sp/を含むものをSP /sp/を含まないものをPCとして 新しい列に出力したいです。 条件設定の仕方として、 ③一致する値が行に無い場合は何を書き込みますか? デフォルトの値を書き込む「PC」 ④検索する値を入力「/sp/」 ⑤書き込む値を入力「SP」 と設定していますが、④のところの条件指定は完全一致でないと「SP」と出力できません。 ここは、何か正規表現で記載すれば〇〇を含むで指定可能でしょうか?
-
Dynamic Average Quadrant Lines in Bubble Chart
Hi all, I really enjoy these bubble charts, but to orient the user it would be great to add horizontal and vertical averages. Is there a way to put a formula into the Quadrant Lines input rather than go to each chart and manual input them? These charts update weekly so would be great to have these lines dynamic. Cheers,…
-
Different Speed of Running DataFlow at different time of the day
Hi everyone, Happy new year! I observed that the same dataflow runs at a different speed at a different time of the day. Sometimes the dataflow runs for 20 minutes, sometimes for up to 1 hour 40 minutes. What could be the reasons why dataflows run at a different speed? Could it possibly be due to dataflows being queued for…
-
Data update issues
Is anybody having dataset update issues? I had workbench errors this morning and now I can't update my excel files.
-
Using case statement to make a value if null and run a calculation if not
I'm trying to find the availability of an application for each month using two date fields in our incident data. I've got it to give me a number when the data exists (the calculation is summing the difference between the times for a given month -> subtracting that number from the total number -> dividing that difference by…
-
Transform Syntax in Workbench 4.5
I'm not an SQL expression expert but I feel like I shouldn't be having this much difficulty creating a transform in the calculation builder of Workbench. (I'm very proficient with Beast Mode syntax, but I realize this is different) I want to take a string (type) column and only use the first 6 characters from the data.…
-
"Invalid Formula" when trying to sum columns
I'm trying to create a formula where it sums Q1,Q2,Q3 and Q4 Actual spends so that I can then do the same thing with Q1-Q4 Projections to find the delta between them, but I keep getting the error shown on my screenshot. Any advice?
-
APPROXIMATE COUNT (DISTINCT) or COUNT (DISTINCT)
Can anyone explain the difference in these two functions? Why use one vs' the other?
-
Delete Blank Rows in Table Chart with columns built with BeastModes
Hello: This question looks like another one in this section but it is different. I have a Table chart with only the first column being a field from the card's dataset and all the other columns are BeastModes Columns that depend on the Time Period selected by the user. I get lots of rows in this Table Chart with no info…
-
Has anyone successfully utilized Domo to look at reporting from Eloqua?
Hello! We've been using Domo for a little over a year now and I we are starting to use Domo for some of our campaign reporting. Does anyone have any advice or tips for getting started with using Domo for Email and Campaign reporting from Eloqua? Thanks!
-
What is the best way to pull Adobe Analytics in to Domo?
Hello Domo - Adobe Analytics Ninjas, Is anyone aware of the best way to extract the full historic data from Adobe Analytics and set up daily data append? I see that the Adobe Analytics regular and the advanced connectors have limitations in terms of maximum elements being only 4. Email connector doesn't see to have the…
-
Domo Connector IP address
Hi, Can anyone please provide the IP addresses of the Domo Connector, so that we can add the rule in our firewall to access MS SQL database.
-
How do I create a card to pull in the weeks forecast for multiple zip codes?
I would like to create a simple card in table format that pulls in the 5-day weather forecast for 11 different Zip Codes. I would prefer something visually appealing for a quick glance at the weather for our service territories. I do not need to cross-reference it against past sales.
-
Is there any Disaster Recovery Plan and Higher Availability solution in DOMO?
Hi, I am looking out for a sloution to Disaster Recovery Plan and Higher Availability solution in DOMO.
-
Using "domo token add"
So I had my admin generate me a token (since domo login requires username/password.) I've logged in using that token (domo token add). However, when I try running my custom app, I'm getting an error from domo.get() along the lines of No DomoApp found for id <xxx> Intiuitively this makes sense since I created the DomoApp…
-
How do you create a Active Directory in DOMO
How do you create a Active Directory in DOMO?
-
how many dimensions and measures we can show at a time in Tabluar form?
how many columns we can show at a time in tabular format using domo table view. and how many rows we can show at a time using domo? thanks in advance
-
Signed up with wrong company, how can I delete the auto-generated domain and my account?
Is there a way to "nuke" my dojo account? I need to delete the auto-generated dojo domain because I signed up with the wrong company and e-mail.
-
Unable to find power user forecast dataset for Domo ETL training activity
Hi, I could not find Power User Forecast dataset for Domo ETL training acitivity in the dataset list. Power user sales dataset were available. Can someone upload the dataset or give access if available. Thank you, Regards, Pramod.