-
Case statement clarification
This seems pretty straightfoward, but I wasn't able to find a definitive answer searching Domo or Google. We're hoping to clarify whether the beast mode formula (case statement using "OR") will return a total count of five (5), i.e. count each row one time or eleven (11), i.e. instead counting EACH instance of a condition…
-
Calculating time increment/differences between Agent Statuses & variance between them
Hello Dojo's! Trying to see if the request we received can be done at the card level with a beast mode calculation rather than a MySql Dataflow, similar to something that was used in this instance (not the exact same but in the ballpark, so to speak:…
-
Exclude data (COUNT) that doesn't meet a predetermined min/max # value
We're trying to determine the number of customers that have to call more than a certain number of times in order to have their concern/issue resolved, i.e. those who are not able to receive first call resolution. Domo obviously can determine the number of times a certain phone# has called in, and we've generated a card…
-
Variation on adding Multiple Targets in a chart?
Saw a great hack in How to add Multiple Targets in one chart? (https://dojo.domo.com/t5/Card-Building/How-to-add-Multiple-Targets-in-one-chart/td-p/2634); it was really quite helpful, already found use for it on a couple cards so thank you! That said, wasn't sure if I should open a new thread since my question was directly…
-
Change Color Rule on Final Drill Path for Quick Filter statuses?
Checked prior to submitting but not finding anything, and if I had to guess it's unlikely this is an option unless there's a beast mode that can accomplish what we're looking to do. We had multiple cards to show agent statuses, and in the final drill path, depending on the agent metric being measured we could set to a…
-
Hide Series from the Legend when NOT null
Searched using several different phrases but wasn't able to locate anything from previous threads on this except "Hide Series from the Legend when Null" which didn't help in this situation, so figured it would be quicker to post since it seems like a pretty easy question to get an answer for, or be advised that at this…
-
Card building question no longer appearing after edits?
Just wondering if there's a known issue with questions being posted in the Dojo Community after an edit is made? This happened a while ago but I just reposted, figured I did somethign wrong, but it seems to have just happened again so figured I'd post. Submitted a question today at 4:10pm (Hide Series from the Legend when…
-
Re: Date/time field split to time only, data SUM, and in 1/2 hr increments (12 hour format)
Good evening! I've checked and spent some time on this but can't seem to find info related to exactly what we're trying to accomplish, nor have I been able to figure it out on my own (newbie here, VERY limited experience, sorry). We converted the `StartTime` column, which includes both time & date, to TIME only but as…
-
Re: Date/time field split to time only, data SUM, and in 1/2 hr increments (12 hour format)
Good evening! I've checked and spent some time on this but can't seem to find info related to exactly what we're trying to accomplish, nor have I been able to figure it out on my own (newbie here, VERY limited experience, sorry). We converted the `StartTime` column, which includes both time & date, to TIME only but as…