Rvannoy Member

@MarkSnodgrass Hello, I am trying to look my data just 4 week in the past and then in a sperate report 4 weeks looking forward. The 4 week back and 4 week forward is working but when I try and sperate them to just look 4 weeks back and then 4 weeks forward I cannot seem to get it to work. CASE WHEN `Ship_Date` >=…

@GrantSmith Sorry, formula is CASE WHEN `Ship_Date` >= CURRENT_DATE() - INTERVAL '4' WEEK then 'Include" else 'Exclude' end) The 4 week backward and 4 week forward formula is working fine. I need to have one that looks at the data for a 4 week backward-looking and a separate on 4 week forward-looking. There is other…

@GrantSmith Hello, I am trying to look the data just looking at 4 weeks back and then on a sperate card looking 4 weeks forward. When I use the formula (CASE WHEN `Ship_Date` >= CURRENT_DATE() - INTERVAL '4' WEEK then 'Include" else 'Exclude') It is not giving me the data for just the 4 week period. What am I doing wrong?

@GrantSmith Thank you this worked

@GrantSmith I created the beast mode on the card using the case statement as shown above. replacing 'date_field' with ship_date the formula was accepted. (CASE WHEN `Ship_Date` = CURRENT_DATE() - INTERVAL '4' WEEK AND `Ship_Date` = CURRENT_DATE() + INTERVAL '4' WEEK THEN 'INCLUDE' ELSE 'EXCLUDE' END) When I use the beast…

@GrantSmith I will try this and let you know how it goes.

We already have the data on the data set grouping by week.

@MarkSnodgrass when I use sum without distinct i sums all the all the numbers. The number should be 1 but if 2 customers have a allocation of 1 it shows as 2 . I used distinct so it would show each distinct customers allocation. Is there a way to use distinct and have the grand total on the table sum all the numbers?

@GrantSmith I have the total row on the table enabled. The grand total is calculating as 43.70 and it should be 56.60. It is not totaling all the numbers. This is an example of my beast mode: SUM(DISTINCT(CASE WHEN `CustomerName` LIKE'%VICTUS%' THEN .08 WHEN `CustomerName` LIKE'%WENPHIL%' THEN .15 WHEN `CustomerName`…

OK, I know what is happening but do not know how to fix it. I got it to sum the numbers but it is only using the number once. Example is if there are 3 customers with a distinct number of 1.5 it only uses the 1.5 once not 3 times. The below is an example of how it is summing. The highlighted are duplicates of the the…

When I click on the pencil and just change the format calculation to SUM it does not change the numbers but the Grand Total is off. This is the total when I export and sum the column. This is the sum in DOMO. Not sure why DOMO is not getting the correct Total.

When I use Sum it sums all the numbers not just the total. Not sure why it is changing all the numbers.

Taking the quotes off worked and allowed it to be a number. When I put it in a table how to I get the total to be the sum of the numbers? The grand total is coming up as When I export it to Excel and sum the column it is 56.90 is the correct total.

That coding is telling it what quarter return (Q1, Q2, ect...). I have tried it with and without this particular string. I will keep working at it.

The checkString worked. Thank you

Thank you I tried the suggestion but it is still not excluding the blank cells. It is still showing the blank cells when I filter by include. If I use the formula: IFNULL(`vessel`,'exclude') by itself and it works, but I can't get it to combine with the other logic.

Thank you I tried the suggestion but it is still not excluding the blank cells. It is still showing the blank cells when I filter by include. If I use the formula: IFNULL(`vessel`,'exclude') by itself and it works, but I can't get it to combine with the other logic.