-
Table, compare several month-over-month
This seems to be similar to the thread located here, but a little more extensive as we're looking to create a table that would compare several months as opposed to just two. https://dojo.domo.com/t5/Card-Building/hello-how-to-compare-month-to-month-with-secondary-axis-in-card/m-p/38214#M5099. And it looks as if a table…
-
Beast Mode error message (dividing by zero)
We're trying to find the variance of Actual from Forecasted but running into the Zero Division issue; read a few other threads, all of which were far more involved Beast Mode formulas, and tried as best I could to adapt those formulas to our situation but having trouble getting it to work - any help would be greatly…
-
Determine percentage of repeat callers (beast Mode or ETL?)
Good morning. We've been trying to create a beast mode to help us determine the percentage of repeat callers and while I can picture in my mind what needs to be done, we've been unable to determine a working calcuation for it. In the image below, there are 14 distinct companies/phone#'s and a total of 33 calls.…
-
Calculate employee occurrences (absent, late, etc) from REHIRE date
Hey all. Wondering if anyone would be able to assist with this. We have a card (simple bar chart) where we show employee occurrences, e.g. absent, late, early out, etc based on a dataset that pulls together a couple different tables, assigning point values to these occurrences for a sum total (absence = 1 point | late <=10…
-
Domo alerts to Slack using Tray.io
Good afternoon. We submitted a case to Domo Support but also wanted to post here since they'd previously advised other customers had found a work around using Zapier and various automation applications related to this request, though it's unclear if they were trying to have the alert as detailed as we're looking to do: We…
-
Best practices for joining multiple external/3rd party datasources in Domo
First off, not sure I'm posting in the right forum so please let me know if this should be moved elsewhere! I'm guessing many other organizations out have dealt with something similar and hope you may have some feedback on how you resolved this. We tend to use a lot of 3rd party applications (Talkdesk & Intercom for…
-
Counts for 2 separate dates columns in a single month (SQL Dataflow)
Good afternoon. We had previously requested something very similar and accomplished it via Magic ETL but want to do the same thing, only this time using a MySQL dataflow instead of Magic ETL (previous thread - split & reappend a dataset). We've looked for documentation but unable to find anything; can anyone direct us to…
-
Excluding weekends (using DATEDIFF function to identify employees first 3 days as training)
A search for Exclude Weekends and Exclude Weekends using DateDiff Function returned a few results, none of which would seem to work for what we're trying to do so checking to see if we can get some help on this! We're trying to add, in the dataflow itself, as part of the output dataset, a transform that would add a new…
-
Average for Nested Bar instead of Total, or another option?
Good morning. We'd like to show the average of the two bars in this card, and ideally it would be using a Nested Bar chart but open to other suggestions (currently using a Grouped Bar chart). CURRENT: NESTED BAR: The Value is a beast mode, which takes into consideration the actual sale amount less the valuation, divided by…
-
Sorting question
Jus wondering if anyone else has seen this and what the cause might be, or how to correct it. We have a standard Grouped Bar + Line chart and are sorting by the metric used on the X-Axis, but for some reason those that have no delay, i.e. not between 0-XXX, appear at the top instead of at the very bottom, below those with…
-
Beast Mode assistance (issues w/month-over-month calculations for 12 month table)
This is a followup to a thread from last month (Table, compare several month-over-month). We've created a table card that for the most part function as requested, but noticed a few things that need to be accounted for and we haven't been able to figure those out at this time. In the screenshot below, we have a…
-
Attendance Occurrence Count
We've been able to accomplish a good portion of the original request within dataflow w/transforms rather than a beast mode, and we'd like to complete this request but need assistance on the last piece of it as the information available online hasn't helped as we'd hoped. We were told that this would fall under Gaps &…
-
Track Attendance Occurrences
Hi. We've been asked to track occurrences (absence, late in, early out) for a rolling 30 day period for employees. We're importing an Excel spreadsheet through Box from our 3rd party HR application and have the data required in that dataset but having trouble trying to accomplish this in a beast mode, and not sure if the…
-
Getting DateDiff to show decimal places
We're using two date fields in a card and are trying to show a difference between the two. The source data shows these w/decimal places (screenshot) but our card didn't, couldn't understand why but when viewing the data table at the bottom of the card, it seemed it might be caused by the PickupDate being YYYY-MMM only,…
-
Join twice on a different column (only 2 input datasets)
I've looked but unable to find anything to indicate it's been asked or that it's ever been addressed but we're looking to join an input dataset 2x (same column) to the other input dataset but on a different column each time; is this possible? Example: Table 1: Conversation Assignee and Conversation Rating Assignee (Dataset…
-
Series Formatting (various types, i.e. Currency, Percentage, etc)
Just closed out a case w/Domo Support on this on this request; it's not built in functionality at this time though a good argument was made for it to be considered for a future release and it was submitted as an enhancement request. Were trying to show Total Cases (Y Axis, this is no problem), but then also show Total…
-
Converting String To Date so it shows as an option for DATE FIELD in Summary Number
Good morning. Not sure what it is that we're missing but for some reason the only data avialable to choose in the DATE FIELD dropdown (series of screenshots below) is _BATCH_LAST_RUN_, which is not the date field we need to show CURRENT in the top level summary number. We've converted Last Viewed from text string to date…
-
Multiple date columns (count) from single dataset - using 12 month calendar NOT from dataset?
I've read several posts on things simialr to this, but not sure that this exact issue has ever been brought up or of it's even possible. We've been running into an issue when trying to create a Line + Grouped Bar chart that would require data from two separate date columns (ReviewedDate and ResolvedDate) in the same…
-
Summary dataset (from detailed dataset)
We have a dataset (agent hours) that contains cumulative/summary data by status/day, and a beast mode to determine the total number of hours worked (something along the lines of start time - non work activities/statuses - end time = total actual hours worked), plus another dataset that is detailed/transactional for…
-
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…
-
HTML/CSS issue (Summary# data showing on separate lines)
Did a lot of reading from previous posts about using HTML/CSS in Summary#'s and wanted to give it a try for a card, and while it looks great and provides a very effective quick view to determine lost time, can't seem to get this to display properly, i.e. on a single line (we wanted to make the lost time standout, using RED…
-
Show sum of two averages in summary number (already exists in nested coumn)?
Thought this would be easy but haven't been able to get it so that BOTH of the average times for a `status` ('break' and 'unscheduled break'), which are part of a nested bar chart, can be used in the summary number - currently, we've only been able to get it to show 'break, not both totaled as is visible in the chart. None…
-
Negative numbers (trending upward for positive direction, vice-versa for negatives??)
Not sure if this would be considered the same as/similar to this inquiry from a few years ago (https://dojo.domo.com/t5/Card-Building/How-do-I-add-a-trend-line/m-p/6573#M344) but we haven't been able to locate a Regression Line section in chart properties within Analyzer to try that (deprecated?). What we're looking to do…
-
Effect of adding new column to imported data on an existing dataset/dataflow
Good afternoon! Not sure if I'm using the correct search terms but we haven't been able to find anything related to this question by one of our managers, and before changing anything we wanted to confirm whether or not it would cause any dataset/dataflow or card issues. We currently upload a file to Box each week, which is…
-
Nested bar, sorting low to high by TOTAL
Good morning! I've done several searches on both Domo and Google for this but nothing comes up, only for Stacked Bar graphs though it would seem to me that someone would've run into this before! When using a Nested Bar graph and drilling down to the first drill path, seems we're unable to sort (low to high OR high to low),…
-
Case Statement (dividing by specific conditions)
Good afternoon, Dojo's. We received assistance in another thread (https://goo.gl/i5cVjC - thank you @RGranada!) but needed to expand upon the original beast mode to determine a completed percentage for only certain individuals as opposed to company-wide and @Valiant suggested it's best to open a new thread for this request…
-
Add field/dimension not yet available in a dataset
I hope this doesn't sound like a stupid question, because we understand WHY it's happening, but it's something we've struggled with for some time now when trying to keep filters updated and cards accurate - it's been a very painful, time-consuming manual process thus far. So, we add a dataset & card, and set filters for…
-
Is a Case Statement using COUNT / SUM possible?
Good morning. Not sure if it's the case statement itself, i.e. incorrect syntax or if there's an issue related to divide a COUNT by a SUM value. We've also tried to run this as COUNT / COUNT but to no avail. We'd like to use only certain agents when trying to determine a Completed Conversion % for offers. The beast mode…
