-
Beast mode - no aggregation
Hi Everyone, I created a pivot table that will show the cost of dispatches. Please see below: one of the values that we are using is called Number of Ports ( blue Value that says COUNT of Nu. ) and for some reason the number does not populate any data even though on our tickets it shows a number. And maybe because that's…
-
Is beast mode needed?
Hi Everyone, I created a card that uses a date_time_start dimension along with a ticket count on a metric table. This card shows the number of tickets that have a scheduled dispatch showing date and time. What we want to do is turn past tickets to red except for today's and we used the Last 7 days by hour but the date…
-
How to add a new control variable
Hi Team, I was hoping you can assist me on adding a new control variable. Having some issues adding it. I have a card where its showing single value data that are in a status- Pending NI. So total number of tickets that are in Pending NI. And these Pending NI have dates on when the dispatch will happen. I want the user to…
-
beast mode question
Hello everyone, I'm having an issue trying to get this beast mode calculation validated. We have tickets that is suppose to be updated but we want to track tickets that are not updated within 4 hrs. And we want a color change when ticket is about to breach 4hrs with no update. I wrote this but getting syntex error. if…
-
beast mode
hi everyone, Im in need of your assistance on completing a beast mode please. I have data that lists out site names on each row with service types but I only want sites that list the 3 types - EPIK or Greenix and Survey and Cutover and Test Like the image below: and this is what I have so far but not giving me the correct…
-
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…
