-
Filter Month based on Last working Day
Today is Monday March 3rd. I am using the following Beast Mode (shared previously in the forums) to filter to current month: Case WHEN DAY(CURRENT_DATE()) = 1 AND DATE_FORMAT(`Event Date`,'%m-%Y') = DATE_FORMAT(CURRENT_DATE()-1,'%m-%Y') THEN '00-Current Month' WHEN DAY(CURRENT_DATE()) != 1 AND DATE_FORMAT(`Event…
-
Custom Color by Value in Symbol + Grouped Bar Chart
In my chart, the target value is the symbol. I have two series one that is showing daily value and the other showing month to date value. I would like the color of the bar for the daily value and the color of the bar for the monthly value to be green if target is met, yellow if value is 95% of target and red if value is…
-
Drill Down Aggregation Issue
We are using Domo to visualize our manufacturing data. There are planned hrs based on the number of parts and the amount of time it should take to manufacture those parts. Then there are actual hrs, which is how long it actual takes to manufacture those parts. Efficiency is calculated by dividing the planned hrs by the…
-
Join vs Append
I have one dataset date/dept/machine/product/defect/no of def. Second dataset is date/dept/machine/vol. There will be multiple defects on the same date from the same dept and same machine (defect and product may differ). When I join this causes the vol to duplicate for each product / defect entry. How do I create a beast…
-
Beast mode to find last working day
Trying to figure out a beast mode that will filter my data to the last working day. Business works Monday-Friday. Want to be able to set chart to yesterday so that for daily morning chart shows yesterday's data. On a Monday it would pull data from Friday instead of Sunday. If there is a better way to do this other than a…
