I have a data set which contains a column for URL's for file a user has upload and a second column that contains the type of file that has been uploaded. I have created a beast mode that displays a thumbnail of any uploads that are images. I now want to display an icon for items that are not images but cannot get the icons…
I have data coming in from a sql table, and I cannot change the datatype of it at the source. I'm trying to join on the columns but it won't join on certain rows of data b/c One column is varchar25 and the other is nchar10 from the SQL Server side it comes from. They are already string, so when I use the Magic Tile to…
I can't seem to get a magic to work, nor can I seem to get a beast mode to work. I am sorting data by month. If though, my data does not have data for May (5) then I want there to be a row for May, even if there isn't data. Somewhat obviously, a case statement wont work because again, when there is no data, then no row.…
I am having an issue where the days in the 12/31/2023 week cross into 2024. I am summing hours worked for the week, but it only returns half of the hours. I have tried creating a new column to concatenate the year-month using various formulas noted below, but I still get the 'The calculation contained a syntax error'. Is…
I am having lots of trouble trying to figure this conversion out.. I have an excel file that I am bringing into domo.. within the card (table format) I am trying to get the average (as the average column already existing cannot be properly summed within domo). I am trying to take the 'talk time' divided by 'call id count'…
Hello, I created a card where users can filter multiple IDs at once. This is useful to quickly filter the card based on the account IDs that we got from another card. Users can simply highlight all the Account IDs, copy and paste them in the Input Text Box The variable is called enter_account_ids. Is there a better…
Hi community, I'm new to domo and need some help. I have a simple data set (see below). I want to only view rows that have an order date. if it's blank, i don't to see it. I was hoping to use the filter but I can't figure out how to exclude blank dates, i only get options to filter by various date ranges. Or, what would be…
I got this code to work, well kind of. Its only returning 110 CASE When Actual bid 2 >2700 THEN 120 When (model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110 ELSE 110 END Tried this CASE When Actual bid 2 >2700 AND model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%' THEN 110 when 'actual bid 2' <=2700 then…
The specific task is to identify if a truck is a F-250,350, 2500, or 3500. The Column is "model" that I'm looking for the partial match in the model column. I keep getting syntax errors. CASE WHEN `model`LIKE ‘%F 250%’ OR `model` LIKE ‘%F-250%’ OR `model` LIKE ‘%F250%’ OR `model` LIKE ‘%E-350%’ OR `model` LIKE ‘%E-250%’ OR…
I'm trying to solve a problem where I want to compare the average of two columns based on the value of another column. A simplified version of my data table looks something like this: Score A | Score B | Score C | Survey Type 10 | 20 |19 | pre 14 | 26 |23 | post 7 | 6 |8 | pre 10 | 10 |12 | post I want to calculate the…
It looks like you're new here. Sign in or register to get started.