-
Adobe Illustrator - Design App Studio
Hi Guys, I am currently trying to connect to the Design App Studio in Adobe Illustrator however when I go to extensions and click the Domo Design App Studio it loads a blank page. I have tried using a previous version to no avail. Can someone help me work around this? I have been tasked to build some custom apps to make…
-
Beast Mode Calculation
Hi Everyone, Trying to come up with a beast mode calculation to calculate the percent difference between last weeks count and this weeks count. This is the example of how the data would look: Also I would like to know how to do a rolling 4 weeks count so an additional field with header 4 week count and then the percent…
-
Domo Design App Studio - Adobe Illustrator
Hi, Is anybody using the Domo Design App Studio with Adobe Illustrator? If it's functioning can you please let me know what version you're working on of the creative cloud, illustrator, and domo design app studio. This would be very helpful if someone is still using it successfully. Thanks!
-
Beast Mode Calculation Subtotal/Total
Hi There, I have a beast mode calculating utilization and I want the calculation to occur in the subtotal and total as well however it is not doing that for HTML or Mega Table. It appears to be Summing or Counting. Can someone please assist? Please let me know how I can rectify this. Thanks!
-
Division by Zero ETL Formula
Hi everyone, Can someone help me with this issue... trying to input a formula in Magic ETL and I got a division by zero error. How can I rectify it? I know in some cases the divisor in my calculation will be 0 but that is okay. Case when `ServiceName` like '%Manual_Only%' then (`InCallMin`) /…
-
Dynamic Text to work with Global Page Filters
Hi, I am trying to create a dashboard that has data from various datasets but each dataset has its own date column. I want the dynamic text to work with the Global Date filters - not finding anything within the knowledge base of this. I've found if I clicked on a specific graph with the month it would drill down the data…
-
Formula to Remove Duplicates and keep Max Value
Hi, I am currently looking at some records where customer's accounts were waived. However a customer can have two applications waived the same day (maybe they drew on the account two different times so there are two applications on an account for them.) I want to remove the duplicate record and keep the record showing the…
-
Current Date to EOM Filter
Hi Team, I'm trying to filter some data but what I want it to do is to filter based on the date you're going into the report and end of the month. Example if I go in today it would show me the pending arrangements for 8/9 to 8/31 and tomorrow would be 8/10 to 8/31, etc. I'm thinking I have to do a beast mode for this, but…
-
SLA/Response Time Beast Mode
Hi Team, I am currently working on response time for tickets, we eventually want to get to SLA but since the metric will be new for this team we need to understand the average time it takes to handle a ticket. I am currently using the below to get the average response time displayed as HH:mm:ss…
-
Beast Mode - Count Case When with multiple criteria
HI, Trying to use the below to count when both criteria are met. If an agent has a record for a specific date count 1. (CASE WHEN (COUNT(DISTINCT `ReportDate`)) >= '1' and (COUNT(DISTINCT `Agents`)) >= '1' THEN '1' ELSE ? END) It is not allowing me to calculate this. Can someone please assist?
-
Formula to search text
Hi domo fam! I am currently working on two ELT formulas: the first I am trying to search a string field column named Note for a specific text. However the way the text is stored in the row it is “Bankruptcy Record-then a break line-Dismissal Customer confirmed bankruptcy on 01-01-2021” I want to search for all notations…
-
Beast Mode Not Allowing Card to Save - AVG SLA BEAST CALCULATION, HELP?
Hi, I previously created a table card where I was able to add the beast mode below but when I needed to make an edit I was unable to save as it gave the Unable to Save your card contact your Domo Support Team. Below is the table card I am trying to save: The beast mode for AVG SLA used. When I delete this beast mode I am…
-
Card from Outer Join Two Datasets ETL
I'm trying to join two datasets, each dataset has a date field, how can I join the date field to get one Date Column that I can use on the X Axis, but will not remove any rows from the other columns. 1st dataset has: created date, complaints cases, end date, customer type 2nd dataset has: balance date, loan in books,…
-
Table from Multiple Datasets
Hi, I want to create a table that will pull data from multiple datasets. For example: each dataset has user name and data fields. 1st dataset has: username, date, ticket type, count by type. 2nd dataset has: username, date, inbound calls, outbound calls, productivity. 3rd dataset has: username, date, net collected,…
-
% of Total
Hi, I am currently working with a dataset with text values that I want to count and get the percent total. I can do the count since Domo allows you to count text values, but I can't do the % total. I wanted to include another column that would give the sum of the count, then I would be able to do the % total. I tried…
-
Shape Gauge
I have a data set that lists the NPS rating a customer inputs on all our interactions. The customer has the choice between 0 - 9 to input a score. The data is in an excel file, I have uploaded this in the workbench. I am trying to create a shape gauge card that will display the count of each choice. I am inputting my…
