-
Using Explain Plan to check Mysql query performance
Hi, I am trying to run Explain plan on my queries to check query performance. When I use the SQL transform I get a message saying the statement is valid but it does not show any output. When I use the Table transform it throws an error saying it needs to be a SELECT statement. So I was wondering is there any alternate way…
-
Calculating weeks on hand based on forecast of subsequent weeks
Hi, I have the following dataset: Item Date Projected Inventory(PE) Forecast(FC) A Jan 28, 2019 604 50 A Feb 04, 2019 630 52 A Feb 11, 2019 1303 49 A Feb 18, 2019 1257 46 A Feb 25, 2019 1176 51 A Mar 04, 2019 1136 55 A Mar 11, 2019 1083 53 A Mar 18, 2019 1030 53 A Mar 25, 2019 980 50 A Apr 01, 2019 900 65 A Apr 08, 2019…
-
Self Join Outer JOIN not working as expected
Hi, I am trying to do Outer Join on the same table. However I am not getting the result that is expected. I have the following dataset: Item Country Event Date Event Event Order A US Apr 29, 2019 Out Of Stock 1 A US May 13, 2019 Back In Stock 2 A US Oct 14, 2019 Out Of Stock 3 A UK Jan 28, 2019 Out of Stock 1 A UK Feb 04,…
-
Comparing WTD Sales upto the current time for last 3 week
Hi, I want to compare WTD Sales up-to the same point in time for the past 3-4 weeks. The Period over Period chart only compares WTD sales at the end of the day instead of up-to the current point in time. How to achieve this in Beast Mode or Dataflow level? Thanks, Prajwal
-
Adding missing day rows
Hi, I am trying to get data for everyday in a particular date range even if there is no data for that day. For example, Item Location Date Count A USA Jan 3, 2018 5 A USA Feb 10, 2018 12 A USA Feb 25, 2018 13 A Canada Jan 7, 2018 14 A Canada Feb 10, 2018 10 A Canada Mar 3, 2018 5 Desired O/P: Item Location Date Count A USA…
-
Adding a new date column which is based on another Date column
Hi, I am trying to build a card that shows the items and the date it goes out of stock and the date it comes back on stock. I have the following dataset: Item Country Date In_stock In_stock_previous_week A USA Sep 17 0 1 A USA Sep 24 0 0 A USA Oct 1 0 0 A USA Oct 8 1 0 A USA Oct 15 0 1 A USA Oct 22 0 0 A USA Oct 29 0 0…
-
Replace Undefined/Blank with a value in Beast Mode
Hi, I am calculating accuracy with a formula inside Beast Mode: (A - F) / A * 100. There are few instances where the denominator is 0. For those instances, I am getting blank values as shown below: I want to replace the blank/undefined with a different value I tried to use the CASE and IFNULL BeastMode functions but that…
-
Calculating a value for current week and rolling that value for subsequent weeks
Hi, I have the following 2 datasets: Dataset A Item Location Date X Y A USA Sep 10(Current Week) 10 10 A USA Sep 17 15 20 A USA Sep 24 10 5 A Canada Sep 10(Current Week) 0 4 A Canada Sep 17 6 0 A Canada Sep 24 13 15 B USA Sep 10(Current Week) 10 50 B USA Sep 17 5 15 B USA Sep 24 15 20 Dataset B: Item Location Z A USA 15 A…
-
How to reduce SQL Dataflow runtime?
Hi, I was wondering if there are any effecient ways to reduce the MySQL Dataflow runtimes? Please provide any tips/tricks. Thanks in advance.
-
Grouping multiple values in a column into a single column
Hi, I have the following dataset: WhseLoc Proj Inventory Previous Inventory Country California 18 20 USA Atlanta 21 22 USA Columbus 19 20 USA Toronto 0 25 Canada Ottawa 0 20 Canada Vancouver 15 30 Canada I want to get an output dataset as follows: Country Is_out_of_stock USA No Canada Yes The conditions are: Proj Inventory…
-
Grouping Dates with consecutive weeks
Hi, I have to visualize Projected Out of Stock Items and the date it goes out of stock in the inventory. I have a table which shows when the item may go out of stock. This table shows the Projected Inventory for every Monday of the week. Item Location Projected Inventory Date A1 L1 0 Aug 20, 2018 A1 L1 0 August 27, 2018 A1…
-
How to group smaller valued groups into one single OTHER group?
Hi, I have a dataset where some of the groups are in Millions while there are several others which are in 1000s. So these smaller groups appear really small in the stacked bar visualization. I want to group these smaller groups into a single OTHERS group. How do I achiece that in DOMO? Regards, Prajwal
-
Difference between dates
Hi, I am trying to create a visualization which shows the difference between 2 dates and the trend of the date differences over time(what is the average difference in dates and how they have changed over time). How can I achieve this on Domo? Regards, Prajwal
-
How to change the structure of a dataset from wide format to long format?
Hi , I am new to Domo and I have to work with a particular dataset which is sent by Avercast, an Inventory Forecasting and Demand Planning software company. The data uploaded into Domo is in a wide format. It has seperate columns for Date fields and I want all these columns to be grouped into a single Date column. Is it…
-
Calculating Weeks on Hand for an item based on subsequent weeks of forecast
Hi, I have the following dataset: Item Date Projected Inventory(PE) Forecast(FC) A Jan 28, 2019 604 50 A Feb 04, 2019 630 52 A Feb 11, 2019 500 49 A Feb 18, 2019 450 46 A Feb 25, 2019 1176 51 A Mar 04, 2019 1136 55 A Mar 11, 2019 1083 53 A Mar 18, 2019 1030 53 A Mar 25, 2019 980 50 A Apr 01, 2019 900 65 A Apr 08, 2019 853…
