-
How to always correct the date to the 1st.
Hello all, I want to know the code for ETL "Add Formmura" function. The column ”Data” will always contain a value for the year, month, and date. When the value comes in , I want to set the date value always to 1st by using " Add Formmura" function in ETL as like below picture. Could you let me know the code to enter into…
-
Curved line + stacked vertical bar
Hi, I have two question for the card of Curved line + stacked bar(Vertical bar) I would like to change curved line "A" to "BGT". Please let me know how to change.(Question1) Now I have only one curved line in the card. But I would like to create two curved line of "BGT" and "B" in the card. ( I want to set "A" as vertical…
-
How to indicate the values of two columns on Y axis
Hello, When I use the card of Curved line + stacked bar, it is possible to indicate the values of one column divided to Var and curved line by series on Y axis. But it is impossible to indicate the value of two column on Y axis. Please let me know how to indicate the values of two columns on Y axis.
-
How to append monthly data?
Hello, Please let me ask how to append monthly data to accumulated data. I want to append monthly data using DataSet via Email Connector on the accumulated data from January to April. For example, I upload May data by using email connector in May, the output dataset will be for January-May data. However, after that I…
-
How to add pivoted value to new columns by Magic ETL
Hello, I would like to ask how to add pivot value to new column by Magic ETL. I prepared the table as follows which have value of product for 2021 Apr-Jun and previous year of same month. I want to add rows and columns highlighted in yellow as shown on the right table by Magic ETL. The rows that I want to add is 2021 Apr,…
-
Pivot card
Hi, I would like to know about Pivot card. I prepared the table below. The four fruits of "Product" have a value in Jan, but only grapes does not have a value in February. I visualized this data on a Pivot Table card by analyzer. Is it possible to put the name in product in order as I like? If I visualize only February on…
-
How to output list which can't be joined
Hello, I would like to know how to output list which can't be joined. I would like to join two list as below with "Product". My ETL is below. I could join the data. I would like to make one more output as below data. "grape" in Product in left list is not existed in right list. So I would like to output this data as well.…
-
Dataset upload by sending email attached excel file
Hello, I heard that it is possible to set that if I send email attached the excel data and it can be uploaded the Dataset in Domo instance owned by the dataset owner. It seems that the Dataset is automatically uploaded by only sending excel file by email. Could you let me know how to do it? Do I need apps etc? Thank you.
-
How to indicate story pages and regular pages on page list
Domo has two types of pages : story pages and regular pages. I would like to create a list of pages that I manage like this. Usually I use the Governance dataset when I list up page info, but the Governance dataset seem not to have a column that could output about the page type. Could you give me some advice if you have…
-
putting excel data in Domo
Hi, Usually when I put excel data in Domo, I click 3 steps. 1.data 2. File 3.more upload methods But today, I try to put my excel file into domo instance, only white screen pop up after click "more upload methods" and I couldn't put my excel data to domo. Has there been any revision by uploading the excel file to Domo?…
-
Impact of deletion ETL, input datasets
Hello, Let me send my question. Several Input datasets, ETL, one output dataset, and the cards are linked in sequence. Those input datasets are no longer updated, so the output dataset will not change anymore. As a result, ETL and input datasets are no longer needed. If I delete the ETL and those input datasets, will the…
-
Cancel sharing all cards on a page
Please let me ask to solve my issue. For instance I shared Tom to PageA. All cards on PageA are shared to Tom automatically, and Tom can see all cards on the pageA. After that, I canceled sharing PageA to Tom. Although I canceled sharing PageA to Tom, all cards on the PageA remained to be shared to Tom still. Is there any…
-
Domo Governance Datasets Connector
I have generated "Page and Card" by connecting Domo Governance Datasets Connector. When I searched a specific page ID on the generated data, the page ID was not found. But the page ID exists in my Domo instance and my account have access to the page and also to the connector. Why does not the connector have all page ID?…
-
Government Datasets and Activity Log including Card ID and Page ID
Hi, all. I tried to count the number of time of "VIEW" of specific cards existing on several pages by Activity Log. For the reason Activity Log has no records of Card ID and Page ID both, Card ID and Page ID cannot be linked. I would like to know who viewed the cards from which page. Is there any way to get log data of…
-
Data table
Hi all, I displayed the Data Table on the card. At present, it shows PAGEA and PAGEB vertically in order. Is it possible to change this order like PAGEB PAGEA? Japanese-- カードのData Tableを表示しました。 現時点では PAGEA PAGEB と並んでいますが PAGEB PAGEA のように、この順番を変えることはできますか？
-
Why it doesn't filter as I expected
Hello all, I created a card from the dataset. The card setting is as follows. When I filtered "Card Title" to be equal to "null" by QuickFilter, the count of action is expected to be 2. But actually The count of action shows 0. What was wrong? Chart type = Bar X AXIS = Name Y AXIS = Count of Action SERES = Page name Quick…
-
ETL Rank&Windowでの累積列追加
Dojo「仲間に相談」のトピックスでご指導いただき、ETLのRank&Windowで用いて累積列をもうけました。 月の順でSUMし、値が空白になったらその前までの累積したいです。 （列「Result」には0の場合は0と入りますので、空白になったらその後は必ず空白です） Rank&Windowの④ではどのように設定すればよいでしょうか。 よろしくお願いいたします。
-
累積グラフ（Running total Grouped)で翌月以降を非表示にする方法
累積棒グラフにおいて、売上個数の予測は年間表示するが実績が途中までしかない場合、累積棒グラフで表示すると期中の実績以降の累計が同じ値で表示されてしまいます。そのため実績がまだない期間について棒グラフを表示しないように設定することは可能でしょうか？ 例えば、いま4月だとして、5月以降の実績がないので、添付エクセルのような表になっているとします。 こちらの表を Chart type で Running total Groupedチャート にしますと、予測と実績が両方とも年間分表示されてしまいます。 それを、実績だけ当月までの累積表示にしたいです。 （下図は図形で棒グラフを隠したりして修正してみました。このような図にしたいです↓）…
