BlueRooster Domo Employee

So the reason it's doing this is that your category columns are being viewed as a text column instead of numeric. What you would need to do is add a separate column for ordering and then sort by this new ordering column. That will keep your categories in the correct order. Let me know if you have any other questions on how…

I would suggest altering your CASE WHEN by adding in an ELSE clause (after the ...then 'Guest Users' and before END). Something like ELSE 'Outlier' And then you can filter to only view your Outlier values and see what conditions those rows have and as to why they aren't being caught in your CASE WHEN. Hope that helps,…

Not sure what particular type of image you're looking for, but this is a good resource site: https://commons.wikimedia.org/w/index.php?search=svg+human&title=Special%3ASearch&go=Go Lots of different svg options for you to choose from. Hope that helps, Valiant

You could use the DAYOFWEEK() function to do this. https://www.w3schools.com/sql/func_mysql_dayofweek.asp A filter for this might look like: CASE WHEN DAYOFWEEK(`date_column`) = 6 THEN 1 ELSE 0 END Then filter it on is equal to 1. That will only allow Friday dates in your card. Hope that helps, Valiant **Please mark…

There's a couple different ways to handle app sizing. This link talks about how to build a responsive app: https://developer.domo.com/docs/dev-studio/building-a-responsive-app This one is your guide on px sizing your app based on the grid dimensions you define:…

You should have access to an 'Auto-Preview' option in the top right of the analyzer. If you don't see it, it may be worth reaching out to your account manager and see if it can be added for you. Sincerely, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in…

This sounds very similar to a previous issue that was addressed here. It also includes a few way to handle your total row: https://dojo.domo.com/t5/Card-Building/Table-Card-Total-Rows-Incorrect/td-p/36669 Best of luck, Valiant

So if I understand you correctly, you're looking to find the Max Amount and the period that the Max occured on for each location? If that's correct, you should be able to modify your current dataflow and add a Rank & Window tile in the ETL. Choose Rank from the functions listed, set the summed amount column as your column…

I'm not aware of a way to view DataFusion runtimes. (All the Domo Governance datasets are around Dataflows). I did run across this link that my be helpful. It talks about some things to check when experiencing slow DataFusion run…

Without resorting to 3 different cards and setting full size to something like 1x3 blocks (which is often how I would handle your scenario), your only other option for having 3 separate y-axis' like your screenshot would be to build a custom card in the design studio. When the new Storytelling/Layout functionality is…

Can you provide an example of the output you're seeing? I'm not seeing any issues with your code at first glance.

Under Chart Types -> Table, choose the Textbox type. Then it's just the Card name at the top and Value shown for the number. See if that's what you need, Valiant

Ok, so I'm going to assume that for the current month you're using your Forecasted Production and anything prior to that is actual. Forecasted Production beastmode: CASE WHEN `Date` >= DATE_FORMAT(Current_Date(), '%Y-%m-01') THEN `forecasted_production` END Actual Production beastmode: CASE WHEN `Date` <…

So you can recreate that using the Line + Stacked Bar. I did a quick mock-up below. The way to do this is to set your Date as your X-axis and then break it into 4 measures using BeastModes. (You can do this with Case When statements, let me know if you'd like more detail around this). Once you have the 4 measures, add the…

You could use the Text type chart and use the following BeastMode: CONCAT(`Video with most views: `,`ViewCount`,'<br>',`Name`) Just add in the count and name columns where appropriate. Hope that helps, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the…

Have you tried using the Period over Period card? Is there a reason you're trying to do this manually? Take a look here: http://knowledge.domo.com?cid=buildingpop If that won't work for you, can you explain a bit more about the final result you're looking to acheive? Are looking to create 1 or card or multiple? Sorry for…

Since Domo is based on MySQL, most anything you can do there will work in Domo. The answer on this forum talks about how to relate a FIXED function to SQL. You may be able to follow a similar path: https://community.tableau.com/thread/236716 Hope that helps, Valiant **Please mark "Accept as Solution" if this post solves…

When editing your stacked bar chart, under the General section of Chart Properties there is an option to sort categories Ascending or Descending. Sounds like you're looking for Descending. Hope that helps, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in…

I'm fairly certain you'll need to use a SQL transform to make this happen. Here's how i would approach it: If you're finding min time by ID then I would do something like this SELECT `ID`, DATE(`Time`) AS 'Day', MIN(`Time`) AS 'MinTime' FROM dataset GROUP BY `ID`, DATE(`Time`) Then use this to create a flag for your…

Initially I would definitely say there's a learning curve (as with any new software). Now though, I'd say the time to value from importing data to having a working card is the fastest of any other BI product I've used (Tableau, Power BI, IntelliFront etc). There are some great tutorials for each card type…

The only way that may be possible that I can think of is if you have access to Domo Embed, and then were able to use the embed link paired with a dynamic link based on which row of the table card you were displaying. This is definitely something you'll need to reach out to your account rep on as they should know who from…

Sounds good. Any chance you can provide a few rows of sample data for me to play with? The beastmode I gave you does the following, replaces the first ':' found between date and time with a space. The second part removes the ' +0000' part of the column and the last part is just the timediff conversion. Basically it's…

There is currently not an option to change format for scheduled reports. There are several ideas in the ideas exchange though regarding this. This would be a great addition. Sincerely, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped…

So is this just a list of requestIDs and requestTimes? Are you using the requestTimes to calculate your dates as well? Are there multiple instances of a requestID on the same day? (Ex, does requestID 5 get called 10 times with 10 responses?) If so, can you explain a bit more about what you're trying to calculate? Are you…

In the chart properties under General. There is an option for 'Sync 0 Lines'. (You can also Sync Value Scales if you want) It sound like that may get you what you need. 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.

How is your Name column structured? Is there always a space in the column, with or without the last name? If there is no space for those single word names you can do something like this: CASE WHEN `Name` LIKE '% %' THEN LEFT(`Name`, INSTR(`Name`, ' ') - 1) ELSE `Name` END Hopefully that'll get you started on what you need,…

You should be able to have this turned off if you reach out to you account manager. They should be able to either do this themselves or reach out to the people over at Beta have them do it. Sincerely, Valiant **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the…

This will flag a 1 for 'in your range' and 0 for out. CASE WHEN `Date_Field` > LAST_DAY(DATE_SUB(current_date, INTERVAL 13 MONTH)) AND `Date_Field <= LAST_DAY(DATE_SUB(current_date, INTERVAL 1 MONTH)) THEN 1 ELSE 0 END That should hopefully help get you what you need. Sincerely, Valiant **Please mark "Accept as Solution"…

Still not a great option available that I'm aware of. Can't use RANK or ROW_NUM functions at the card level and you still can't set a max # of columns returned for the Pareto card :( I feel like there might be an option using interaction filters but I think it would be cumbersome in practice. And the name change was just…

We use the card definition field for this. Aside from an explanation of the card, when we get to defining how we calculated something we will surround the equation with * Like this: * x + y = z * In the card definition, that causes it to bold the lines between the two astrisks. Maybe that will help with what you're after.…