Tomo Contributor

Comments

  • ステータスを重複で更新しました！ ↓同意見の方はこちらにイイネお願いしますー https://dojo.domo.com/t5/ひらめき共有/DataSetのデータを個別で削除したい-ソートもしたい/idi-p/23727
    in データセットを複数行削除したい Comment by Tomo February 2019
  • Hi @bahrittknee Not all rows are used in DataFlow preview. Is not it the cause? In ETL, I think that only 100 rows are used.
    in Group By value with Average aggregation calculating differently Comment by Tomo March 2018
  • Hi @Randyb BEAST MODE case when DATE_FORMAT(`FirstRODate`,'%m%d') in('0101','0401','0701','1001') then `OpsNetSales` else 0 end How about this BEAST MODE expression?
    in Determining if a record falls on the first day of a quarter and if not collect it in the next Quarte Comment by Tomo March 2018
  • Hi @user07805 BEAST MODE sum( case when `Coverage` = 'Covered' then `Dollars` else 0 end ) / nullif(sum(`Dollars`) ,0)
    in Beastmode syntax for the following condition help Comment by Tomo March 2018
  • Hi @mccreathbecky If the original data is all UTC, setting the time zone from the administrator screen will convert Domo when importing data. https: // [your-instance] .domo.com / admin / companysettings Time zone However, this function can not be used if the original data is AEST or GMT. In this case, you need to set the…
    in MySQL using different timezone to workplace setting Comment by Tomo March 2018
  • Hi @cjones An example of BEAST MODE or DataFlow SQL. -- DayOfQuarter case when month(`Date`) <= 3 then datediff(`Date`, concat(year(`Date`),'-01-01')) when month(`Date`) <= 6 then datediff(`Date`, concat(year(`Date`),'-04-01')) when month(`Date`) <= 9 then datediff(`Date`, concat(year(`Date`),'-07-01')) else…
    in How to Get Quarterly Trend Numbers Comment by Tomo March 2018
  • Hi. @artywah Is it possible to avoid by replacing the date that is incorrectly converted by using regex? Set Column Type Column : DateColumn Data Type: Text Pattern A　YYYY-MM-DD (TEXT) Set Column Type Column : DateColumn Data Type: Date Format : Year first Pattern B YYYY-DD-MM (TEXT) Replace Text Column : DateColumn Search…
    in Specify different date formats for multiple sources in ETL Comment by Tomo March 2018
  • 残念ながら簡単な方法は現在無いようです。 BEAST MODEでは別行の全体を分母にする割合計算はできなので、 @ユーザー07557さんの書いているとおり、DataSetととして全体数値を持っておく必要があります。 又は、テーブルカードを諦めて、率部分だけ円グラフなどで表示します。 私も、どちらかの方法でカード作成しています。
    in テーブルカードでの全体数値からの割合表示の出し方に関して Comment by Tomo March 2018
  • @ユーザー03866さん DataSet名に「・」や「、」があると外せなくなる不具合があります。 プレビューも見れないかと思います。 サポートに連絡済みですが、まだ直っていないようです。
    in SQLで入力Datasetを外そうとすると「Sorry! エラーが発生しました。」と出てきて外せない。 Comment by Tomo February 2018
  • Hi. @user04420 In "Step 2 - DataSet", select the column to filter. In "Step 3 - Access groups", specify values to be filtered for the column selected in Step 2. In the attached image, it seems that "filtering value" is not set in "External Reporting Group". An example Step 2: eternal_reporting_1 - FILTER ACCESS…
    in Domo Publication Groups Comment by Tomo February 2018
  • Hi @user06832 It is the result correctly converted to timestamp type. We convert it with BEAST MODE at card creation and use it. date_format(`datetime`, '%Y-%m-%d %H:%i:%s')
    in How to change the format of the replacement variable ? Comment by Tomo February 2018
  • Hi. @AttuAk CHART PROPERTIES > General > Unsorted Data:　ON SORTING > [Sort Column] [Sort Column] Make BEAST MODE case when `EngagementType` = 'High Engagement' then 1 when `EngagementType` = 'Medium Engagement' then 2 when `EngagementType` = 'Low Engagement' then 3 else 4 end
    in How can I sort the legend values in a Pie Chart Comment by Tomo February 2018
  • Hi. In my instance, the Publication Group is available. It seems that you have to contact Domo support. https://knowledge.domo.com/Administer/Controlling_Access_in_Domo/055Setting_Up_Publication_Groups --- To request that this feature be enabled, * contact Technical Support by messaging /support in Buzz or via the Support…
    in Is publication group going away (getting retired?) Comment by Tomo January 2018
  • Hi. Add a line number using DataFlow. Use the card's Quick Filter and set it to the default 50 or less. To download all lines, unset Quick Filter or set it to 0 or more. === DataFlowを利用して、行番号を追加します。 カードのクイックフィルターを利用して、デフォルト50以下に設定します。 全行ダウンロードするときは、クイックフィルターの設定を外すか、0以上にします。
    in Table Export Comment by Tomo January 2018
  • Hi. Add "EventSequenceNumber" as DataFlow as below. MarketingIDEventIDEventSequenceNumberEventCostm01e011110000m01e021210000m01e022310000m02e100130000m02e300230000m02e500330000 BEAST MODE: MarketingCost sum( case when `EventSequenceNumber` = 1 then `EventCost` else 0 end )
    in Summing unique values based on a separate column Comment by Tomo January 2018
  • Hi. BEAST MODE sum( case when `Status` in ('accepted','finished') then 1 else 0 end ) / nullif(count(`Status`),0)
    in count specific values in a column Comment by Tomo January 2018
Avatar