GrantSmith Coach

You can keep the format as xlsx I’m just recommending making a copy of the xlsx as a csv and uploading that copy

You can change the aggregation in the field properties of your fields you added to the chart. Here is a KB article for reference https://domo-support.domo.com/s/article/360043429573?language=en_US#totals_subtotals_individual_columns

Currently there isn’t an option to have workbench do this do your script is still needed. I’d recommend adding an idea to the idea exchange to add this enhancement to workbench

Graphing by week or month would cause duplicate records to display with the window function because the date slice is different than what you’re ordering by.

You should be able to set up different alerts filtered to different users and then assign those alerts to those users. Then you can do the same but change the criteria to be two weeks for the Manager version. You could combine all of the individual users for the manager and just check if there are any greater than 2 weeks

You can utilize python packages such as pandas to read the excel file and convert it to a csv and then upload it to Domo that way.

There isn’t a way that Domo provided to drill into a card programmatically. I’d recommend adding this as an idea to The idea exchange It may be possible to utilize some low level JavaScript and DOM inspection but it’s a very technical route and I haven’t done it myself yet but just an idea

Have you tried utilizing <br> instead of \n? Is it actually displaying \n or just not doing a new line?

Have you validated the data you're getting back from your SQL query? Is it returning all of the data you're expecting?

This sounds like a bug as per the documentation: Workbench creates a log table with the same name as the DataSet name mentioned in the Overview tab. I'd recommend logging a ticket with Domo Support to have them help diagnose your issue.

If you're looking to add raw data to your dataset within a table card that isn't possible. You need to use an ETL to transform your data (i.e. adding rows in your case)

My favorite vacation was in Bryce Canyon hiking with the family. It was an amazingly beautiful place and a lot of fun to get out and go hiking. Going to Lake Michigan is always a fun weekend retreat to spend some time at the beach.

FIXED would allow you to restrict the filtering however ranking isn't possible with a FIXED function because it doesn't allow an ORDER BY clause. Regular window functions are affected by filtering. I'd recommend adding this as an idea to the Idea Exchange

Have you tried taking the CASE statement outside of your FILTER ALLOW clause and surround your entire fixed window function in the CASE statement based on the variable?

Currently there isn't an option for this however I'd recommend logging an idea in the Idea Exchange for others to vote on it and perhaps have Domo add it.

Currently this isn’t possible but may be in the works. There is an idea exchange post requesting this functionality you can upvote here: and also https://community-forums.domo.com/main/discussion/57808/reuse-beast-mode-field-in-another-calcuation#latest

As this app is developed by Domo you’ll need to contact support as it sounds like an issue with how the app is trying to send your data.

Currently Variables only support storing a single value so checkboxes are not an option for variables. I'd recommend adding this to the idea exchange to have variables support multiple values.

You can utilize what Domo calls a Beast Mode or Calculated Field. You can refer to their documentation on the Knowledge Base as a good starting point: Also, Domo does provide a Pivot table for you to use as a visualization if you're needing that type of visualization.

Create a duplicate beast mode with the same logic you're using to create the ranges but instead of returning the ranges return a number to sort on (0, 1, 2, 3 etc) then use that new sort beast mode as your sort on your card.

If you copy and paste the actual arrow instead of the code it should work for you

This is an issue with X / Twitter's API usage restrictions coming from Domo. You'd need to reach out to Domo Support to have them help you with this specific error as it's their API connection that's being utilized to pull the data.

@Tung Currently there isn't an option to hide the others. As you can see there's a lot of great ideas coming from the community and more than one way to do something within Domo. Welcome to the forums!

@Jean_McDonald Yes, the Domo Dimensions Calendar Dataset has dates through 2030 in it so you can view future dates.

Domo doesn't have a way to display a vertical line as you're wanting. You could utilize a beast mode to check to see if it's today, if it is return the value. CASE WHEN `dt` = CURDATE() THEN `random_number` END You can utilize a symbol line to display your values and then have Today being displayed on top of it like this:…

Currently this isn't an option. You're not able to dynamically set the column labels like you're wanting to do. Have you looked into utilizing data labels and tool tips in your visualizations?

Here's a link to an existing Idea Exchange post to create something like a block tile which may be similar:

@MichelleH has written up a great article on the community blog you can reference on how she did geospatial distance calculations using a Redshift dataflow.

You can't aggregate your data three times. Try taking out the SUM(`Loads`) in favor of just `Loads`. Same thing for the carrier pay field. Also another alternative to DATE_FORMAT(CURRENT_DATE(), '%Y') is just YEAR(CURRENT_DATE())

You could configure a beast mode to return the opposite and then do a NOT IN CASE WHEN Target Go-Live Date` IS NULL THEN 'Blank' ELSE 'Not-Blank' END Alternatively if you're wanting to do that exact value then set the Blank value for when it's populated. Do your filtering then change your beast mode back.