Randyb Member

@rhollander There are a couple of ways you can do this, you can download the excel plugin which then allows you to pull the data down along with the different PDP profiles. You can then build essentially a user list for a specific PDPPolicy and upload it. Its been awhile since I've had to use it but it does make large…

You should be able to download it from the Admin/Tools Download section. Randy

Have you tried the Excel plugin for DOMO, this allows you to apply PDP security to any dataset you want and is a fast and easy way to apply PDP policies that are exact copies to other datasets. Just change the DatasetID and apply and your good. This is also very easy to make slight modifications to PDP's that are close but…

The reason for that is more of an underlying structural component of DOMO. When you run SQL statements there are two things that DOMO does or doesn't do that impacts the run time of the SQL. First, the resources it applies to the SQL run is not as great as the resources that are applied to anything that is run in the ETL.…

Its most likely doing that because of the report component which is different it appears on each row. If you sum the count(Distinct) it should give you the value of 5 that your looking for. If I'm interpreting this correctly. Randy

No problem, I'd be glad to help Randy

Although I haven't used it myself I have been investigating using the Split Column function in Magic ETL If your data your referncing is contained in a single column and laid out as you indicated you should be able to split the single column into 4 columns using the | as the customer delimiter. Hope this helps point you in…

Not sure if you ever got any info on Data Assembler, if your still looking for some info let me know, I have been using for about 5 months now and it is really quite amazing, especially if you happen to working with real time live data and need to grab snapshots of certain elements over time. Let me know if I can help…

Thanks, I didn't think I could use Left() on a Numeric value. I had to modify it slightly to Max(Left(mydata,10) That gave me the trim value and still only returned the single RO Really appreciate it. Thanks Randy

So I kept working on this since it appeared as though it was stumping the community at large and I have come up with a solution that works if anyone is interested. The Beast Mode below checks to see if the Month Current date - "the months back you are going" falls into last year by producing a negative value. It also…

So I tried using this Beast Mode in a modified form and it works until I cross into the prior year, not sure what type of case statement will qualify the year and make the appropriate adjustment. Here is the orginal Beast Mode that gives me last months active Employee Count: Sum(CASE WHEN `hireDate` <=…

Ok, I figured it out, now feeling a little on the dumb side, I had a sort order in there that I wasn't paying attention to that was based on termination date. As soon as I removed the sort order i got my single row as I was expecting all along. Thanks for you help. Randy

The two columns were nothing more than two different versions of the Beast Mode calculation. It doesn't change anything if I have either one or both of the coumns, I still end up with a value for each employee. That is what its showing, there are 18 rows and there are 18 employees at that particular location. So it is…

I was able to do the trim and then convert the column in the ETL itself so no longer a need to do this in the Beast Mode. Thanks Randy

I ended up using it and it worked fine, gave me a little more flexibility as well, thanks for your help Randy

Thanks, I'll do some investigating, I was really hoping to stay away from the Beast Mode approach as this was going to support another calculation that I wanted to keep in the dataset. I may have to be willing to compromise a bit as well. Appreciate the advise, will advise as to what I end up doing Randy

Doesn't look like you can search for Null values in ValueMapper, because its a date field your searching for it is forcing you to input a specific date to search Randy

I think you have a pretty good understanding of what I'm trying to do. Your solution 2 is the approach that addresses my issues but how would I make the Uncollapse Column entry if I don't have a static RepairOrderStatus like Closed, Open etc. All I have are date fields, so I know the status is closed if the…

Its not you it was me, I knew what I wanted but not being sure how to get there it was a bit of a hike, but your responses started me down the right path. I made a couple more changes to get all the date possibilites covered, here is what it looks like. case when DATE_FORMAT(`FirstRODate`,'%d') > '01' and…

Ok, I think I have it, this Beast Mode does exactly what I want, now my question to everyone is am I wanting the right thing, am I going to be able to group the data on this like I can with any other date field?? case when DATE_FORMAT(`FirstRODate`,'%m/%d') >= '01/01' and year(`FirstRODate`) = year(`FirstRODate`) AND…

Not sure that will work because they are going to want to see this as Year over year along with a number of other Region, Market etc filters. I've gotten even closer yet, this Beast Mode gives me Quarter and Year and now advances the quarter by 1, except in Q4 I end up with Q5. case when DATE_FORMAT(`FirstRODate`,'%m/%d')…

Ok, so I've come up with perhaps a better approach, although this Beast Mode isn't pretty it looks like it would work if someone can help clean it up. I decided if I creat a new field which basically converts the FirstRODate to a new date, I'm sure there is a way to do this based off of the other two answers where I don't…

There is a syntax error in it somewhere, still trying to find out where. Randy

So if Im reading this correctly it is saying that if the firstRODate matches the 1st of any one of those quarters then OPSNetSales. If this is correct then how do I move it to the next quarter if it doesn't match. So to describe it better if I have a FirstRODAte for a location that is 01/01/2018 then all RO's would be…

Here is the Beast Mode I'm using to get the current month count, there are two variables I'm looking for in this Beast Mode and I'm just adding the two together, if you only need to measure one varialbe then you could just drop one of them: Case when YEARWEEK(`hireDate`)<=YEARWEEK(CURDATE()) And `dateOfTermination`is null…

That worked, I built out a calendar table that had the date, whether or not it was a working day (WHich allowed me to input the Holidays) and then an additional column for days remaining. I then joined it to the main dataset using the last update date. Now every day I have one date set and it tells me how many working days…

I have resolved it, although quite a bit more complex than what I was hoping for but it works very well, here is a copy of the Beastmode that is gathering the total active records for the prior quarter. I have a similar one for each date range I'm pulling for, by current month, prior month, prior quarter, prior 2 quarters…

I've got a bouple of other issues going on that I discovered but I think this is working, thanks for your help Randy

The date of termination is a date time field however the time value doesn't change it is always 18:00 I'm digging into the results detail and doing a comparison using hard coded dates to validate one more time, it may actually be working. Stay tuned. Randy

I tried it but it still didn't work, it produce the same values as the current month and current quarter which tells me its still not breaking out of 2018. That is the issue I'm having is that right now everything is returning 01 2018 as the month year and won't go back to 12 2017 for the prior month and won't go back 10…