John-Peddle Contributor

Thanks, @ST_-Superman-_ , we'll give that a shot and respond back/accept answer if we're able to get it to work that way. Appreciate your time & assistance 

Per Domo this capability isn't functional though it's on their roadmap (issue w/Slack requirements and the message body); no timeframe as to when it would become available in Domo. They advised us other customers had found a work around using automation applications, but we've only been able to get Tray.io to pass a very…

@MarkSnodgrass - thanks so much, your solution worked exactly as we'd hoped but... As is the case with most BI requests we receive, the requirements changed a bit and after some work we were able to work with what you gave us and made the necessary adjustments in the dataflow, and used a Line + Bar Chart to show both…

Hey @MarkSnodgrass, appreciate your response and think I may have presented our issue inaccurately so I'd like to provide some sample data to see if that helps clarify the ask. Started to work on a dataflow that breaks out the input dataset into 2 new tables, and attempted to union them to get the results needed but it's…

Chris (@cwolman), that did it! Added the additional transform first in the dataflow, did a couple of joins and now we're able to show the Date (actual date), Start Date/Hire Date (from Employee Roster), User Training Start Date, and User Training End Date for external employees. All calculations appear to spot on, taking…

Chris (@cwolman), apologies but believe I left out a vital piece of information that would keep the solution you provided from working in our instance, very sorry about that. We're starting the dataflow with TWO (2) input datasets: * The first is a manually updated employee roster, and the User Start Date is based on…

Hey Chris (@cwolman), sorry for the late response but thanks so much for your assistance on this! The solution you provided worked but we've now been advised by leadership that an employees start date won't always be same as their first date of work, i.e. scheduled or actual work hours (that's a timedate field, i.e. May…

@ST_-Superman-_would it be ok to DM you, maybe provide some of the raw data we're working with via Excel? Still unable to get this to work as expected, not sure if it has to do with WHAT we're doing or maybe related to the information provided in this thread not being thorough enough to get the correct feedback on a…

Any ideas on why we're unable to get the individual stores to reconcile? Is there anything additional that we could provide to help understand the ask better? Thank you in advance for any assistance on this!

Thanks, @JasonAltenburg, believe that got us in the right direction! Wat we've done is separate the "stores" out into their own columns (Store 1 & Store 2), and you can see from image 1 that only the row of data that applies to that store appears in the store specific column that was created with a beast mode. However,…

Yes sir, @Godiepi, that did the trick! Thanks for the qick response and assistance. Have a great day! 

@ST_-Superman-_ yeah, just found that out (screenshot shows outcome of changing the beast mode similar to what you outlined - adds No Change to some cells and others NaN, but also populates Infinite which is a good thing though it also changes the %'s)! I'll DM you some sample data, thanks for your help on this!

@ST_-Superman-_, thanks for the reply. We added a case statement to the dataflow via transform so that "Has Discrepancy" will always be populated as it corresponds to the ID# (1 for a discrepancy, or 0 when no discrepancies exist). Initially, forgot to update the outer case statement, i.e. MONTH(DATE_ADD) to reflect the…

Hey @DanB, appreciate the response and details provided; it's more or less what we thought but weren't sure if it was possible due to the number of columns we're looking to compare month over month. Quick question: looks as if Domo is/was planning a month-over-month table; would you know if that's forthcoming or has it…

UPDATE: did start a new thead as well since this may not be seen by others who might've been looking to find a solution to something similar. Thanks! https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Table-compare-several-month-over-month/m-p/38216#M6274 @DanB / @ST_-Superman-_ I was going to start a new thread but this…

@DanB - thanks for the clarification, it really helped to better understand the logic behind your initial post. We're currently working on this and appreciate you taking the time to offer a suggestion and then provide the detailed insight for it. Have a great day! John

Dan, Thanks for the response but unfortunately what you've suggested is way beyond my comprehension and skillset; as much as I've tried I'm just not able to follow along and achieve what you're advising can be done with the rank function. Additionally, can you explain why we need to use a separate calendar if both dates…

Actually, once we stopped trying to figure out a beast mode for BOTH it seems pretty simple, just not sure if this is correct: count each instance of Late In and Early Out as .5 instead of 1, which would give us a "2-for-1" count for these, along with an absence (counting as 1). Does that sound like it would be correct,…

Rather than worrying about incorporating a threshold for minutes at this time, can anyone assist with how we'd be able to count TWO occurrences as a single instance for Late In's and Early Out's (i.e. 2 times late, 2 times out early, or one instance of each) in a beast mode? Specifics: - Each absence will count as 1 (one)…

Brian (@Property_Ninja), Sorry for not responding sooner on this! Just wondering, if we wanted to show the number of days plus remaning hours (less than a 24 hours period, do you know how we'd show that in a MySQL TimestampDiff transform? Thanks! EXAMPLE: TimeStamp 1: 2018-10-11 07:01:01 TimeStamp 2: 2018-10-31 14:31:26'…

@NewsomSolutions, this one worked but at first returned a syntax error message (saw that a . was added to `Conversation Rating Assignee.`, but it DOES work as hoped! Figured it would be easy, what's confusing is why it's so difficult to find this solution in a search result; maybe it was the wording used in the search?!?…

Thanks for the reply, @NewsomSolutions, and probably should've added that the solution you provided was already attempted and returned an error message which I really don't fully understand (The database reported a syntax error. Not unique table/alias: 'b'). I'll check out the link you provided, maybe that can shed some…

Thanks, Brian (@Property_Ninja); if doing this in MySQL, your suggestion would be done in a transform, correct? 

Thanks @JSensei, appreciate the followup on this! Have a great day...

Thanks for the response, Aaron (@AS). Tried that beast mode but it's only returning NO values (added the underscore in DATESUB as you mentioned in another thread). Any thoughts on that? For this type of chart, we can only have one series, whether you aggregate the Y Axis or not, correct? In order to achieve a visual…

Aaron (@AS), thanks for the response. Trying the Data Science Bubble Chart but in the original card we have the X Axis using a date and from what we're seeing we wouldn't be able to get a date to display in the test card as we are in the current card. Can you confirm whether or not it's possible for this type of chart…

We're working on doing this in an ETL. Thanks

@mdelorey - had to play with it a bit more to find out WHERE you can add them, but yes, it does allow for multiple instances of joining columns to replace null values. Thanks for the post, this has proven to be very helpful!

@mdelorey - I know it's been a couple years since this solution was provided but wondering if Domo alllows you to filter rows/set constants/combine columns for multiple instances in a single dataset? We have 12-15 columns that have null values that we'd like to replace the w/0's; I'm trying to repeat step 5 (add a new…

Any thoughts or suggestions on this? Apologies if the submission was long winded or possibly confusing, trying to simplify the request here: It's understood COUNT(DISTINCT `PhoneNumber`) will return a count of unique phones #'s, which obviously we'll require, but the problem we're having is determining the count of the…