-
Dynamic Target Based on Current Date
Hello all, I am currently utilizing a gauge card with a target metric. What I would like to do is have the target be dynamic based on a date. For example, we have a different target for each quarter in our fiscal calendar. Depending on which quarter we are currently in, I would like the target to reflect the correct data.…
-
Select Top 1 MySql
Does any one know what am doing wrong here? I am trying to convert a sql statement to Domo Mysql but I am getting an error Original sql: SELECT ta.Item , ta.Warehouse , ta.ShipDate , tb.ActivityDate FROM copy_of_cuts_w_forecast ta JOIN RunningCases tb ON tb.Item = ta.Item AND tb.Warehouse = ta.Warehouse AND tb.ActivityDate…
-
Max Case Statement
Hello! I would like to create a beastmode that will calculate the case fill percentage for the most current fiscal week I have in my data. For example, if I have fiscal weeks 1-45 in my data, I would like the calculate the case fill percentage for week 45 only. Each week I will receive new data, so next week when I get…
-
Filter Removes Summary Number
I created the following beastmode for my summary number. The beastmode works and returns the summary I am looking for. However, when I change the filter on the dashboard (ie to look at a specific customer instead of all encompassing) the summary number on my card turns to zero. Any ideas how I can get my summary number to…
-
Beast Mode works but not in Summary
I have created a beastmode calculation to show as my summary. The calculation works, however when I select it to show as a summary number it returns "No Summary Number". My beast mode is: CONCAT(ROUND(AVG(CASE when LOWER(`On-Time or Late`) = 'on-time' and LOWER(`Drop/Live`) = 'live' then ABS(`Live Turn Time Data`) when…