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…
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 …
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 …
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 ti…
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,…
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_w…
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 …
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 Cana…
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 Can…
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 In…
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…
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 o…
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 fo…
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…
