-
カードの作成日や更新日が見たいです
カード内にて、データ更新日は見れますが、カード作成日や更新日の情報もみたいです。 こちら表示する方法はあるのでしょうか?
-
ETLで日時に9時間足す方法 UTC→JST変換
UTC日時をJSTに直すため9時間追加したいですができず、そのために ETLの後に DataFlow SQL を入れています。 ETCで時間の計算や、タイムゾーン変換はできますか?
-
カード移動に関して
ブラウザを2つ開いて移動させたいカードを複数選択し、ドラッグ&ドロップで移動可能になるようになりませんか? 長らくDOMOを使用すると、1ページに多数のカードが存在してくるようになり、整理が必要になってきます。 現状では1つずつ移動しないといけないので、移管作業だけで膨大な工数が掛かってしまいます。
-
データセットをフォルダーに分けて管理したい
データセットが増えてきたので、 フォルダーに分けて、各データセットを管理したいのですが 今は機能がないのでしょうか。
-
結合したDataSetを自動でExp.する機能がほしい
手動ではエクスポート機能がありますが、 折角便利に結合したDataをより活用できるよう、csvなどで自動で吐き出せるようにしてほしいです。
-
エクスポートの機能がほしいです
インポート機能(コネクタ等)はありますが、自動出力の機能も欲しいです。 現在、RのAPIを利用して出力していますが、もう少し一般的な方法で出力できると助かります。
-
グラフタイプ(マップ)
マップ:日本 緯度経度を入力すると、市区町村単位でヒートマップを作成したい
-
データセットをフォルダーに分けて管理したい
データセットが増えてきたので、 フォルダーに分けて、各データセットを管理したいのですが 今は機能がないのでしょうか。
-
Converting time value stored as text
Hi, I have a column of time value in the format of 'HH : MM : SS' - it is currently stored as text, I want to be able to run some calculation such as looking at the sum, or average of this column. How do I do that? When I aggregate the data, I'd like it to still output as 'HH : MM : SS' on the graph
-
Which data column format is better?
Hey, I'm generating report from one of our platform and have a possiblity to have report in two formats. Let's assume that A-category , B-subcategory, X-random value. First type: A1X1 B11X11 B12X12A2X2 B21X21 B22X22 So in this case X1 is sum of X11 and X12. with DOMO limitation of summing total rows this might be useful...…
-
Domo metrics
How can I force Domo Metrics datasets to update? We have one card (logins by user) which is 7 days out of date.
-
Sparkline
Is there any way to implement something linke "sparkline" in excel? Like this: Thanks.
-
1 trend using 2 columns of data
Is there a recommended chart type or beast mode calculation to show a trend with 2 series data points: e.g. I want to show the trending count of active users; start date is one column, and end date is another. I do not want to show cummulative users (which does not account for cancels/end dates) or gross adds. Is this…
-
Always has timeout when trying to connect to my Mongo database server
Hi, I haven't had any successes connecting to my Mongo database and always have this issue I'm sure I put right Credentials. However, I can't know if my Credentials work or not because I tested with both right and wrong Credentials and the connector always confirm it is connected, and I can't have a list of collections but…
-
I need to add a beast mode calculation that returns the number of days since the last recorded entry
I have a dataset with numbers of incidents and dates. I need to add a calculated field that counts the number of days since the last entry of an incident. The incidents column is a number, thus I want to calculate the number of days since the last time a number was entered. Any suggestions?
-
send selected collection in a page
Hi, is it possible to schedule reports only of a few collections in the page rather than the entire page? Thanks
-
Restrict Data Access for Editor or Participant Role
Hi, I would like to restrict data acess for either the editor or privlidged roles so that user's with these roles are only able to see their own data and the data that has been shared with them. Is there a way to do this? I was hoping that the Editor role would fill this need but seems to be nearly identicial to the…
-
Multiple Users Update Same Dataset From Workbench
Is there a way for two people, both with Workbench be able to update the same dataset from their machine using their ID? Tried just using the same dataset name, but Domo just creates a replica of the data with the 2nd person as the user...
-
FROM_UNIXTIME not returning any results
Just looking for a simple beast mode to convert Unix timestamps into date format. FROM_UNIXTIME(`FieldName`,'%m,%d,%y') This doesn't return any data despite being a valid formula. Everything I've found on the straight SQL function says this is correct and should yield a date. What am I missing? Thanks.
-
Average number
Hi, Please help. It should be easy but I can't find the solution. I have the following data: Date; Bank; Amount 10/29/17; Citi; $100 10/29/17; Citi; $200 10/29/17; Citi; $300 10/30/16; Citi; $1000 I need to calculate average daily amount for Citi Bank for the period 10/29/17-10/30/17. The calculation should be as follows;…
-
Data Science in DOMO
Good afternoon all, I was curious how many data science savvy users we have in Domo Dojo? I sat in on the breakout session with Turo at Domopalooza 2016 about using R to predict car rental capacity. I have been pretty heavy into R the past year or so and build Predictive Tree Based Models and OLS models. I know Domo has…
-
On a line + grouped bar chart, i can't get the week end date to reflect the date in the dataset.
The week end date is a Saturday within the dataset. In the chart, the week end date shows as a Sunday. Example 9/23/17 shows as 9/24/17. I can't remember which setting corrects this issue.
-
Magic ETL Dataflow has no results
Hello, I have a Magic ETL that has an Excel file and Dataflow as inputs i conduct an inner join on a field that i know is on both datasets. On the output dataset, there are no results. I have used this method of joining data successfully before. My only guess to the problem is the length of the join column. Is there a…
-
how do i change a date grain on a card
I've built a card and chosen the date range for card. My data is displaying in "monthly buckets". How do I get it to show daily bars instead?
-
Anybody have a good solution for an indicator card that shows which days are missing data (sales)?
I am trying to create a card that will show which dates in the past 7 days are missing sales data. I am sure the solution is a combination of dataflow work and creative card usage but just seeing if anyone had either already solved for this or had an idea of how.
-
Is there a way to filter a card on columns? Similar to filtering on measurement name in Tableau.
I want to be able to create a card where the user can select the metric they want visible by selecting the measurement name in the filter. My data table is already big and so creating a dataset where i have a column called metric name and a column for the values isnt' really an option. I want to be able to do this in the…
-
Creating New Columns in Beastmode
Hi all, Is it possible to create new columns in beastmode? I have a dataset that has Unique IDS, Date and Type of Contact made with a lead. Some task types are more valuable than others so what I want to do is calculate how many non-valuable task types it takes before reaching 1 valuable task type for EACH unique ID. I'm…
-
Change Date Format
I currently have a date column with data represented in the following format: 2017-10-23 08:56:21 For a full picture, this represents the time of day I received a phone call. I would like to change this so that I can count the number of calls per day and per hour of operation on a chart. For example, for the past month,…
-
Clicks vs Sales Conversion Calculation - Modeling large datasets
New to Domo and have seeking best practice or options for modeling. I have 2 tables - Clicks and Sales. We look at clicks for a given day divided by sales for a given day to measure conversion. The clicks table is very large and approximately 558GB uncompressed, to update data we append. The sales table is smaller around…
-
Sum(Distinct Value) Trying to get the sum of?
I've got a dataset that gives me an employee count and an employee count target by location. When I view this by location it gives me the correct values with the target value coming from the following Beastmode: SUM(DISTINCT `Target`) The employee count comes from this Beastmode: COUNT(DISTINCT `WRISEmployeeID`) When I…