-
Hi I have created a app for SKU data with filters cards and data cards but taking too long to load.
Hi, I have created an app for SKU data with 7 card filters and 5 cards that display data in a table. The data flowing into these cards is from a view I have created by joining three different tables. There are approximately 2.5 million records in this view, but the app takes way too long to load, sometimes 2 minutes or…
-
Hi I had question about a basic beast mode calculation that is not behaving correctly
My beast mode calculation is here which is delivered margin define / qtymarketingforecast : Here are the result but as you can see if you divide the delivered margin $ from qty marketing forecast you end up with a different value then you are supposed to: Not sure what is causing the results to be off since the beast mode…
-
Running into a issue with a field aggregation in domo table visual
Hi I am running into a weird issue in domo table I have multiple metrics inside the table two of the metrics need to be at no aggregation since it is a price and an average of the landed cost, but the rest of the fields need to be summed. Issue I am running into is the first field, which is webretailprice, when that is…
-
Hi I had a question about domo pivot tables and the capacity of fields they can hold
I am trying to create a report that requires a pivot table visual in domo. I have 7 fields that need to go into the rows and 6 fields that need to go into the column, and one field in the value section. The problem I am running into is that after including 7 fields in the row section I have a max limit of 3 fields that can…
-
Hi I had a question about creating a view by joining two tables in the data tab of a card.
I am trying to join two tables to create a view in a DOMO card but I am running into a weird issue. Table 1 has 42.3 million rows and table 2 has 158K rows. When I do a left outer join to table 1 I am getting 297 million rows of data. Why am I getting more data than the two tables themselves it should be less data, not…
-
Hi I am running into a weird issue with filtering on a card
I am trying to filter on only the null values for the fields Date Voided and Date Reconciled. The dataset I am using has data on the lines where these date fields are null. For some reason when I filter on either of the dates on the null value, it does not return any data. No other filters are set on this card.
-
Need help with specific code that is not working in either beast mode or magic etl formula tile
Hi the following code I am using as a filter on my card and have it set to "on list" its called skus to be purged "CASE WHEN On Order = 0 AND (Future Demand = '' OR Future Demand IS NULL) AND (Future Books = '' OR Future Books IS NULL) AND (Reserved + WMAVAIL <= 10 AND WMAVAIL > 0) AND WAREHOUSE_CODE = 11 THEN 'On List'…
-
One SKU has multiple mail date and trying to filter out all skus that have date greater than today
Hi, I am running into a problem with my visual I want to filter out any SKUs with a future mail date but since each SKU has multiple mail dates it is not recognizing the future ones it is going off the first mail date it sees. For example, the calculated field I have created is this "CASE WHEN MailDate > CURRENT_DATE()…
-
Report not saving after bringing in a calculated field within a table but saving fine before it
Hi I am running into a unique issue where I have created 3 calculated fields called PCT AD Cost Dollars (SUM(AdCostDollars)/ SUM(SUM(AdCostDollars)) Over(PARTITION BY MarketingEffortYear) PCT Marketing Demand Dollars (SUM(MarketingDemandDollars)/ SUM(SUM(MarketingDemandDollars)) Over(PARTITION BY MarketingEffortYear)…
-
How to omit values from a field if it contains a letter inside it
I have a really quick simple question I am using the field "item Number" but I need to omit any Item Numbers that contain the characters "A, B, C, P" I tried using the filter tool on the analyzer and used the Match Values option set that to does not contain "A, B, C, P" but that doesn't seem to work Here is the screenshot…
-
How to get the first character of a string in domo beast mode analyzer
Hi I am trying to get the first letter in the product number field. I have created a test field to remove any extra white spaces the product number field would come with and here is the calculation: TRIM(ProductNumber) Next I am trying to use the Left function to get the first letter from that test field without any extra…
-
Using a simple case when function not working
Hi so I am trying to use an if-then statement in beast mode but it is not giving me the correct output. The field I am using in this code is product status and these are following values inside it. What I am trying to do is bucket the values into two buckets one which is repeat and one which is new. The code that I am…
-
How to append data so you can get a snapshot every time your dataset runs
Hi I have created a date field in my dataflow using this formula to give me the current date: DATE(TODAY()) I am trying to use this date field to get a snapshot of the data every time the dataset refreshes. I have my dataset scheduled to refresh every Friday. The first Friday the dataset refreshed it gave me the correct…
-
Creating drill down visuals without having to create a new data view
Hi, I am trying to create a drill-down visual for a bar graph in my dashboard but the fields I need to create the drill-down visual are in another table and when I either join the tables or replace the table for the drill-down visual when I hit save and close it asks me if I would like to create a new view. Wondering if…
-
How to calculate a % of line value from the grand total inside a table in domo card
I am trying to find the percentage of the cost of sales from the total cost of sales. I have used the following calculation in beast mode. (`Cost of Sales` / (SUM(`Cost of Sales`)) However, this calculation is not returning accurate values the lower cost of sales values have a higher percentage than the higher cost of…
-
Trying to use a case statement with a When/Then clause inside it formula is validated but not workin
Hi I am trying to use a case statement with a When and Then clause inside it. The formula I am putting in is basic and has worked for other tables but not working for the one I am currently working with. I have tried these formulas: 1. CASE `SeasonalDescription` WHEN 'Easter' THEN 'Spring and Summer' ELSE 'Other' END 2.…
