-
Google Sheets Text Formatting
Hey everyone! Please view attached screenshot below... I am pulling the data for this card from a Google Sheet that is updated multiple times a day with sales referrals. These referrals have a Representative column for the Sales Reps name. As you can see below DOMO is breaking each Rep into multiple bars. I have tried ETL…
-
Combining Beast Modes - Converting Week
Hey everyone! I am trying to combine these two beast modes but am having a hard time getting it to work. DATE_FORMAT(SUBDATE(`Submit Date`,WEEKDAY(`Submit Date`)-1),'%m/%d/%Y',DATE_ADD(`Submit Date`,27 day)) Is the beast mode I am trying. below is the two separate that I am wanting to combine. DATE_FORMAT(SUBDATE(`Submit…
-
Date_ADD / CONCAT MONTHNAME - Syntax Error
Hey Everyone! I am trying combine two different beast modes I am already using and keep running into syntax errors. DATE_ADD(`Submit Date`,21 day) - Used to add +21 days to submit date for new date I am wanting to add CONCAT(MONTHNAME(`Locked`), (CASE WHEN DAY(`Locked`) <= 15 THEN ' 1st - 15th' ELSE ' 16th - EOM' END) ) to…
-
Graph by 1st-15th / 16th-EOM
Hey everyone! I am using DOMO to run commission reports and I am curious if there is a way to graph by 1st-15th and then 16th to the end of month? I know I can Graph by Day, Week, Month and so on but is it possible to do biweekly? Thanks!
-
Percent- Count Greater Than - Beastmode
Hey everyone, Please view screenshot below. I am trying to find the % of `Secondary Paid` that is above 0. I have been able to break it down with a few different beast modes but I am still not able to get the % of the total that is above 0. Paid = When `Secondary Paid` >=1 then 'Paid' Test = When(`Secondary Paid`)> 5 then…
-
Percent Change Month to Month
Hey everyone! Somewhat new to Domo and having trouble setting up a Percent Change formula for Month to Month. Below is the screen shot of the current card I am using. The claim count on the Y axis is already using COUNT(DISTINCT) but I am wanting to add more to the beastmode. For example Apr is 127 and May is 133 I am…
-
Show Google Sheets text/cell colors in Table
Good day everyone I am just wondering if there is a way to pull the cell or text color from Google Sheets into a Domo Table? We have a google sheet that is updated manually with scheduling information. If an appointment is scheduled then the date is input with red text color, once the appointment has been completed the…
