BlueRooster Domo Employee

You should be able to do this with a BeastMode using a Case statement. This should get you close to what you need: CASE WHEN `has_preview` LIKE 'yes' THEN CONCAT('<a href=', CONCAT('https://full_url_',`presentation_id`,'.mp4 target="_blank"'), '>','Preview', '</a>') END With that, whenever has_preview is anything but yes,…

You should be able to use the collapse columns function in an ETL. @ST_-Superman-_ put together a great walkthrough on this process here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Collapse-Uncollapse-Columns/td-p/25067

If you're wanting to include multple variations of formatting for a single column in a table, you would need to either format the values and add them to a 'TEXT' column type or you could try to create a BeastMode to address the various scenarios you need. Something like this: CASE WHEN `Category` = 'A' THEN CAST(`Value` AS…

Sure, what you would need to do is create a BeastMode off of the indicator value (their health score or whatever you're using to determine which face is shown. For the THEN clause of each possible value, you would enter your CONCAT statement containing the HTML for the image you want. You can use the following link for…

Currently adding a subpage to another subpage is not possible. If that's something you'd like to see in the product you can suggest this as a new idea in the Idea's Exchange section: https://dojo.domo.com/t5/forums/postpage/board-id/Ideas If it gets enough upvotes, it'll get reviewed by the Domo team. Best of luck, Valiant…

This is going to depend on the how that column is being populated to begin with. Does your column always get populated with 3 digits - 6 digits - 4 digits etc? Or are you always looking for the number after the 2nd dash? If it's based on digits you could use a SUBSTRING function:…

If it's just a standard SQL connection, you should be able to query the source data with something like this: SELECT * FROM data_source WHERE [day] >= DATEADD(day, -30, getdate()) If it's a MySQL datasource it would look more like this: SELECT * FROM `data_source` WHERE `day` >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)…

Custom Roles are a feature that has yet to be released to production. When they are you should see them listed in within the product release notes: https://knowledge.domo.com/?cid=currentrelease Sincerely, Valiant

The functionality you're referring to is known as interaction filters and is currently in beta testing. If I had to guess (purely personal conjecture) I would think we might see this being rolled out to production in the next month or so. Sincerely, Valiant 

It was done via the App

Page views are tracked when done from mobile. Individual card views do not seem to be tracked on mobile though. Just tested this with another user. Sincerely, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

So the first step is to pair the 'Working Day of Month' to each date in your range. If you don't already have that, here's a table that I use (accounts for major holidays) see attached. Join that to your date that you're using. I would also include a constant for CurrentDay and Join to that to get the current working day…

Do you already have the fields for number of won opps and number of transactions? If not, what fields in your dataset will allow you to tell if something has been won or not? (You can build a CASE WHEN statement to return on wins for the numerator and a straight count for the denominator). Otherwise all you need to do is…

So what I would do is first take your table of 4 columns and add a new column called 'Prior Week Inventory'. This gives you a baseline to compare against. In a SQL transform you could do something like this. (I'll call your current table datasetA) SELECT a.*, CASE WHEN (SELECT b.`Projected Inventory` FROM datasetA AS b…

So since you already have the values removed for Saturday and Sunday the last step would be to go to the X-axis under chart properties and set 'Never Use Time Scale' to True. You may need to play around with the Date Output Format after that, but hopefully that helps. Let me know if you have any questions, Valiant **Please…

So you'll need to actually get the counts for the possible groups created via an ETL/transform and added in as constants to your dataset. That way you can do something like : `count` / CASE WHEN `group1` = 'a' AND `group2` = 'a' THEN MAX(`aaTotal`) WHEN `group1` = 'a' AND `group2` = 'b' THEN MAX(`abTotal`) WHEN `group1` =…

So both sets of data have the exact same records? There's no like load date column or anything that might be different between the two? If not, I agree with @AS and I would reach out to support to have them check into it. Best of luck, Valiant

I'm not quite sure of the full beastMode your'e using, but I think something like this should work for you: SUM( CASE WHEN `feature_1` IN (0,1) THEN 1 ELSE 0 END + CASE WHEN `feature_2` IN (0,1) THEN 1 ELSE 0 END + CASE WHEN `feature_3` IN (0,1) THEN 1 ELSE 0 END .... CASE WHEN `feature_20` IN (0,1) THEN 1 ELSE 0 END )…

If your table card already has individual rows for customers, you would need to create a BeastMode (Calculated Column) and just enter the following: MAX(`Order Date`) And just adjust if that's not the actual name of your order date column. But that will return the most recent order date found for each customer. If I've…

What you'll need to do is make sure you have the appropriate dataset imported from the DomoStats connector. You can use the following URL, just make sure to enter your own domain name: https://domainname.domo.com/appstore/connectors/com.domo.connector.domostats?origin=dc&classification=API You'll need to select the Dataset…

Try this: SUM(ABS(`Amount`)) ABS by itself doens't combine the numbers into a single value. Sincerely, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you. 

Just checked and there isn't a 'Select only 1' option or anything like that. In your example, it would then show data for both 2017 and 2018, but it's easy to see which options are selected (and perhaps de-select 2017 if that's your goal). Sincerely, Valiant

Users don't get a 'You've been Domo'd' email just by turning on SSO. Technically the users won't have a Domo account until they go to login the first time. That's when their Domo account gets created. (Unless you decide to bulk load your user base in ahead of time) Let me know if you have any other questions. Sincerely,…

I'm going to assume this for a table card in my explanation, but you should be able to modify this fairly easily. Also, youre `TotalDue` field, I'm assuming this needs to be a constant value of all of the item due. If it's not you'll need to calculate that ahead of time and then have it repeat through your dataset, let's…

In the card analyzer, you could use a BeastMode (Calculated Field) like this for the series of your stacked bar: CASE WHEN `Amount` < 100000 THEN 'Others' ELSE `GroupName` END Obviously tweak it to fit your own data and threshold, but that should get you the results you're looking for. Sincerely, Valiant

Unfortunately that option doesn't seem to be available for that chart type at this time. The only work around I can think of would be to calculate the average line ahead of time add that value as a new column to your dataset. From there you can add a second line to your line plus stacked bar and just name it Average. If…

Step one would be to import the pageviews data from the Google Analytics data connector. Once you have the data imported, I would cross check the identifiers you have for the pages and the sale items to make sure there is something you can join on. (example, if WidgetA is on page id 49584 I would go through and add that…

The first step would be to go into the Dataflow History tab, click on the run that failed and it shoud show you which step it's failing at. Once you know that, depending on what you're doing there, I would look and see what the current selected columns types are and play with converting them to full text until you find the…

I was encountering this yesterday, but this morning everything seems to be working again. Hopefully you'll see the same in your environment. I'm guessing it was due to the recent additions I've started to see pop up in the UI. Best of luck, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say…

For your first item, are you seeing any issues with the data or only the visual of seeing which dataset is selected appearing in that box? I haven't ran into any issues in card design with this causing an problem as of yet. For the other two, whenever you go back into your Domo App Design Studio, edit your card in…