user01052

Hi, This beastmode is how i'm getting the metric for active campaigns. COUNT(DISTINCT (CASE WHEN `Campaign` = 'A' THEN `ID` END)) the output is the attachment below. I'd like to take the percentage of each row after summing the entire active campaigns column. For Auto/dealer, I'd like 724.4/2088.6 = 34.6% Hopefully that…

in Beastmode Percentage Calculation Comment by user01052 November 2018

That worked perfectly! Thanks so much!!!

in Beast Mode Embedded True/False Comment by user01052 September 2018

Thanks for the quick response! The problem I'm having is that the cells that are not updated are actually blank, so that's why they're not being counted. Is there a work around to also count the not updated cells?

in Beast Mode Embedded True/False Comment by user01052 September 2018

I actually figured this out. I used this link https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench/Workbench_4/Connecting_to_ODBC_Data_in_Workbench_4

in Using replacement variables Comment by user01052 December 2017

user01052 Member

Comments