-
Previous 4 weeks and next 4 weeks data
I want to scheduled a report to go out every Monday. This I know how to do. I want the report to look at the last/previous 4 weeks and the next 4 weeks. But I want it to do this automatically every week. So every Monday it will look 4 weeks back and 4 weeks forward and the report will send as scheduled. Is there a way to…
-
Map a zero value for weeks that don't have data
when I select a range of dates for say 4 weeks I need it to pull the data for all the weeks even if we did not have any shipments. It is only pulling in weeks that we had shipments. How do I get it to pull in all the weeks in the range I chose on the date selector on my dashboard?
-
How do I aggregate a Beast Mode to a number rather than a case statement?
I have tried wrapping the statement into a Sum statement as well as a Count statement but then it just sums it or does a count. I need it to be a number. SUM(CASE WHEN `Column_1` = 'Value_1’ THEN SUM(`Column_1`) END) When I use the above it sums the numbers and I just need it to give. (CASE WHEN `CustomerName`…
-
I am trying to build a beast mode that compares Quarter over Quarter.
This is the formula I am using but it keeps telling me Invalid Formula : This calculation contained a syntax error. These are my headers: The first part is how I got QTR Lbs. I would like to compare the differences Quarter over Quarter and then format it in percentage. I am not sure what the error is. (SUM((CASE WHEN…
-
Beast Mode exclude or include
I have the below beast mode. (CASE when `vessel`like('%RB%') then 'exclude' when `vessel`like('%ROLL%') then 'exclude' when `vessel`like('%ADV%') then 'exclude' when `vessel`like('%REQ%') then 'exclude' when `vessel`='' then 'exclude' else 'include' end) It is working except it is not excluding blank cells. I thought…
-
Using Checkbox how do you group the dates by week?
Is there a way to show dates as a group using the checkbox selector. example below.
-
Help with exclude formula
Used this formula (CASE when `vessel`like('%RB%') then 'exclude' when `vessel`like('%ROLL%') then 'exclude' when `vessel`like('%ADV%') then 'exclude' when `vessel`like('%REQ%') then 'exclude' when `vessel`='' then 'exclude' else 'include' end) thinking using: when 'vessel'='' then 'exclude' would work to exclude the blank…
