-
is it possible to extract Card data through API?
Hit here, trying to extract data from a specific card. I seem to get pretty close with this https://developer.domo.com/docs/page-api-reference/page But that only tells me of the cards listed on a specific page and nothing about the data within.... I'm also able to query a…
-
See a dashboard on a TV
Hello. When designing a dashboard, every time I add more than a screen's worth of data to the dashboard I get a message from DOMO warning me that the data is tall and that I should be careful because if I display on a TV, the data will not display correctly. That is great. Now how do I display on a TV? The only way i have…
-
Capture Card Summary data on a schedule
Hello. I have a card that is continually counting how many "wigets" meet a certain criteria. The number changes hourly. I'd like to capture that card's Summary number at various intervals (maybe hourly) during the day so I can report on trends. Any easy way to do this? Unfortunately the source data changes when it updates…
-
Ifnull fails
I'm trying to work with Null values but not getting the result I expected. I want to display 0 when The Last Package date field is null, but when I do it, the card fails. IFNULL(LAST_PACKAGE_DATE,0) Here is a video showing that: https://drive.google.com/file/d/1kmObFFgnQ54lPLLcFh3N-3bUmB8NChrZ/view Any suggestions? I've…
-
Edit String in Beastmode or ETL
Hello friends. I have a field where there are outputs like this: "Electronics | Computers & Accessories | Computer Accessories | Printer Ink & Toner" I want to only display the text after the last | separator. So the field would display only: "Printer Ink & Toner" Should I do this in ETL or Beastmode? And how do I do it?…
-
Is it possible to have a Table chart type with one of the columns displaying a barcode of a value?
Hello, I have a rather archaic entry I have to do in one system based on DOMO data. I'd like to use the domo data to make a table of information where one of the columns displays in a bardoce font so the users can print the sheet and scan the barcode. The limited barcode experience I have is that the barcodes I need are…
-
Use "Yesterday before 2pm" in a case statement
Hello all! I'd like to use "yesterday at 2pm" in a case statement. How do I write out that condition? The case statement would look a bit like this. Case when 'date' < "Yesterday at 2pm" then 'yes' else 'no' end Appreciate any help.
-
Compare rows and delete if one of the fields do not match
Hello, I have data like this. 1, red 1, blue 2, purple 2, purple 3, yellow 3,red I'd like to edit the data to show the data like this: 1, red 2, purple 2, purple 3, yellow So I'd only like to only keep duplicates if the first and second field each have a match in the data. Any ideas? Assuming it is ETL somehow but can't…
-
Days since last Wednesday
Hello. I'd like to make a calculated fiield to show datediff('end date','last thursday'). how do I represent 'last thursday' in that? The 'end date' is a sate in my data.
-
Create a date field for TODAY at exactly noon
I wish to compare dates to see if they are before or after TODAY at Noon. the 12:00 noon part is static, but the TODAY part changes every day so I want that to be dynamic. I tried this but it did not seem to work: STR_TO_DATE(CONCAT(CURRENT_DATE(),'12:00:00'),'%m,%d,%Y') Appreciate the help!
-
find max values
Hello, I have data that looks like this: a,1 a,2 a,3 b,1 b,2 c,1 c,2 c,3 c,4 d,1 e,1 f,1 f,2 I want to add a beast mode field so that the data in that field displays like this. In this way the beast mode field would return the highest value from counting the first two fields. a,1,- a,2,- a,3,3 b,1,- b,2,2 c,1,- c,2,- c,3,-…