-
Beastmode to calculate column based on minimum date case
Hi All, I am running with a error with a below beast mode formula : SUM(CASE WHEN DATE_FORMAT(`Date`,'%m') IN (DATE_FORMAT(DATE(MIN(`Date_INT`)),'%m')) THEN `ColumnA` END) What i am trying to do here is sum column A when the condition for month number is same month number to minimum date(first date) in the column but this…
-
Issues with new update on DOMO dashboard
Hi All, I have been noticing quite a lot of changes coming on dashboard format on DOMO, also facing some issues : 1. In Dashboard mode when you drag a image placeholder/card to upload a image it would work. The select image option does nothing. 2. On the main view of dashboard there used to interactive filter option where…
-
Join two dataset with count from another table
SELECT `A`.*,(Select COUNT(*) from `B` WHERE `peoplesoft_india_attrition`.`OU`=`B`.`OU` and `A`.`Job Code`=`B`.`Job Code` and `A`.`Date`=`B`.`LAST_DATE_WORKED` and `B`.`Separation Category`='Voluntary') As Voluntary_Count from `A` Hi All, I am trying to join two dataset keeping one intact and from another based on row data…
-
SUM of CASE in Beast Mode
Hi, I am trying to sum a column based on date value output from another case statement, but i dont see anything getting calculated when i check the formula. there are no formula validation issues. SUM((CASE when (CASE when DATE_FORMAT(`Date`,'%d')=1 then (CASE when DATE_FORMAT(`Date`,'%m')=1 then 'Open Month' else (CASE…
-
Beastmode calculation based on filter value selected
Hi All, I have a quick question, can we create a beastmode calculation based on inputs recived through added filter on cards. Exapample : Dataset has List of Items with Added Date and Expired Date. Filters will have Q1,Q2,Q3,Q4. So if i select Q1 beastmode should calculate Expired Item/Average(List of Item Day1 of Qtr,…
