-
what kind of SQL does DOmo use
Hi everyone, does anyone what kind of SQL DOMO uses? standard or mySQL?
-
beast mode for total active tickets per hour
Hi Everyone, I was hoping to get some assistance on writing a beast mode for getting a table to show total number of tickets per hour. Something like the one below: I have something like this so far- DATE_FORMAT(Date_Entered_UTC, '%Y-%m-%d %H:00:00'), COUNT(TicketNbr) but getting an error when trying to submit it. Any…
-
Beast Mode- SQL code to count how many updates in 6 hour intervals
Hello, I'm in need of assistance please of creating a beast mode but can't seem to write it correctly. I have a table named updates with a column time_start that stores the timestamp of each update. the Rows will be the ticket numbers And I want to group the updates by 6-hour intervals, and count how many updates fall into…
-
beast mode to show how many updates every 6 hours
Hi everyone, I was hoping to get some assistance on creating a beast mode please. We have a data set that calculates how many updates a ticket has from when a ticket is open to close. And now we are trying to get a more precise count on when those updates are taking place. We are trying to get a count on how many updates a…
-
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…
