-
How to remove words from a drop down choice in Beast mode
Hi Team, I was hoping to have some assistance on this request on creating a beast mode. There is a custom field that we have and want to remove characters from the drop down choices and then also remove all the other choices as well. We have drop down choices: Access Carrier- Circuit Not working, Access- Carrier-…
-
How to create a beast mode for 1st initial of first name and add the last name
Hi everyone, I'm having issues trying to get a beast mode to work when trying to get the 1st letter of the first name and adding it to the last name. This is what I have - SUBSTRING('Ticket_Owner_First_Name',1) + 'Ticket_Owner_Last_Name' I've tried different variations of this but can't seem to get it correct. Any…
-
a beast mode that calculate revenues from diff sources
Hi Everyone, I have a data set that shows where our tickets are being created and revenue. And I created 2 beast modes that separate where our tickets are being generated - CASE WHEN Source= 'G360' THEN 0 ELSE 1 END and CASE WHEN Source= 'G360' AND (Board_Name='Field Services - MAC' or Board_Name='Field Services - Repair')…
-
Beast mode question
Hi all, I have a beast mode calculation created which I'm trying to find out the monthly average of open tickets between 5 boards for the past 15 months and this is what I have- SUM(COUNT(TicketNbr)) OVER (PARTITION BY Board_Name ORDER BY last_update)/ DAYOFMONTH( last_update ) But I think the calculations are off. Is…
-
beast mode calculation
Hi Everyone, Thank you for assisting me the last time and hoping the community can assist me once again. I have a table that shows the rows of sites along with columns of how many tickets are associated to the sites and the ticket numbers. The data I need are only for sites that have 3 or more tickets. I've tried filtering…
-
trying to create a beast mode calc
Hello, Can you please assist on helping me with creating a beast mode calculation. I've been trying to create one but it doesn't seem to calculate what I need. The column dimension I have is a ticket count of how many tickets were created on a date entered for each day of the month. The rows are different departments. The…
