-
Can PDPs be created on other Admins?
I need to create a PDP on two datasets where admins only see the data that pertains to them. Is this possible?
-
Converting Decimels Numbers into Hours, Minutes, Seconds
I currently have a column that has decimel numberic values and I need to convert these values into a time format. Please note that the column containing this data is not a Date/Time column. A beastmode or and ETL transformation will work for me. Example: Column contains 2.25, I would like for it to display as 2:15 or…
-
Activiey after a certain time in a DateTime formatted column
I am trying to see activity completed after 5pm, regardless of the day. I am not sure how to even begin creating this type of beastmode (if necessary). My Last_updated_date column is in a datetime format. I need to see the date but either have items color coded if after 5pm or have or have a new column added with a some…
-
First and Last Name in a single Column, when there is not Last Name
I have two beast modes that take the `name` and break it into two seperate "colums" So I can have a first name column and last name column on my table card. First Name LEFT(`Name`, INSTR(`Name`, ' ') - 1) Last Name RIGHT(`Name`, (LENGTH(`Name`) - INSTR(`Name`, ' '))) The issue that I am running into is sometime there is…
-
Datediff Beastmode Help
I am attempting to write a beastmode that will give me all cases (tickets) that have not been updated within the last two or more days. Here is the beastmode I am attemping to create but get asyntax error. Can anyone advise? (case when DATEDIFF(`Current Date`, `Date Last Updated`) >= 2 end) Thanks
-
Converting Seconds Into Minutes
Hello, I have a number column (not date) that I need to convert the number into hours, minutes, seconds (hh:mm:ss). I have now idea how. Example: I need 135 to display as 2:15 and not 2.25.