-
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.…
