MichelleH Coach

@Victoria_G1 "Blank" typically means there is a null (i.e. no value). They empty square is most likely an empty string, which is a text value with a length of zero. Can you share a little more about the formula challenges you're experiencing?

@leaflove Beast modes generally work best when the aggregate function is outside of the case statement instead of inside like this: count(distinct case when `customerID` > 0 then `customerID` end)

@ColinHaze What type of freight are you interested in? We've built some custom connectors for our use cases, but many data sources require API access as part of the contract.

@damen I agree with @MarkSnodgrass' suggestion. Out of curiosity, what are you trying to represent by taking an average of a date?

@damen Does AVG(`Date`) work?

@random_user_098765 You'd likely have to take the same approach as the previous post, however I would not recommend building your chart this way since you have so many lines and timestamps. While you could technically build it, it would be way too busy and difficult to interpret. I suggest using this guide to determine a…

@jimsteph I'd recommend using a Heat Map card: You'll have bucket your data into 15-minute intervals and use diverging colors to show red vs green.

@Dverdon Pivot Table charts don't have a native way to calculate the variance between dimensions (in this case months), so I typically calculate them using beast modes in a Mega Table. Can you show a mock-up of how you want the card to look?

@BethW You could use a formula to add a blank string link this: CONCAT('')

@liminlu Where are your excel files stored? If they are stored on a local network/machine then you can use Workbench to look for a file with that name and upload it to a dataset. There are also connectors for cloud services, such as SharePoint and Dropbox if you use those. Any of these options can be set on a schedule so…

@TC1199A You could also use the following in the formula tile to only keep the characters before the second comma, if there are multiple: IFNULL(left(`city`,SUBSTRING_INDEX(`city`,',',2)-1),`city`)

@emmanuelfabre_1 You can do this using a Group By tile by setting ID as the Group by field and calculating the first non-null value of Source. Then you can join the Group by tile back to the original dataset by ID and replace the original Source field with the one from the Group by tile.

@D_Markley34 I'd suggest setting up a default Filter View to show only active statuses, but users can change that filter if needed

This would be super helpful to make fixed functions more flexible. If a card uses a function fixed by month, then it will show incorrect information if the user changes the date grain of the card. An alternative would be to hide the card's date range altogether, but that also removes the ability to filter by date.

@carled Whenever you are filtering based off of whether a field is null, you will need to create a beast mode field that uses the "is" operator to check for nulls or the IFNULL function to assign a value to rows with null values. Then you can drag your beast modes into the filters section in the Analyzer. case when `Date`…

@Victoria_G1 If you add a field to the "Optional Group by" slot in Analyzer it will reduce the number of rows used in your card, which usually resolves the warning

@MayaU_01 You can use the same formula as before, but with a DATE_SUB function around each instance of Date Closed like this: CONCAT( DATEDIFF(DATE_SUB(`Date Closed`, interval 12 hour),`Date Created`), ' days ', TIMEDIFF(DATE_SUB(`Date Closed`, interval 12 hour),`Date Created`) )

@Victoria_G1 Just to confirm, are you trying to remove leading zeros from the month portion? In other words, should the second row in your screenshot change from "2023-04" to "2023-4"? If so, you could use a formula tile to remove the zeros like this: REPLACE(`Date`,'-0','-') However, note that removing the zeros could…

@brooke_warner I would suggest setting up a PDP policy for those groups with a "Custom filter" access type. Then you can test out a rule that is never true. For example if you have a column with statuses of "Pending" and "Complete", then add your rule to only include rows where Status begins with "A".

@BryantCafferty I believe you can have Domo inherit directory groups from Okta that you can use to manage access without a manual touch. Here are the directions from Domo's Admin panel.

@JunkDoom I don't believe there is an easy way to do this in Dataset Views since they are best used for simple transformations. If you are concerned about materializing a large amount of rows, is there a way you could narrow down the amount of data in your ETL output, like a rolling date range?

@mroker Workbench assumes that all data is in UTC timezone, so you will need to set up a transform on your job to convert to EST. Here is an article on how to do that:

@learningdomo The only way to truly add rows to a table is to add rows to your dataset. If you are just trying to make the table easier to read, I'd recommend adding a beast mode to categorize which rows you want grouped together and use that as a subtotal field.

@ColinHaze It sounds like you are running into conflicting filters by using both the radio button and the date range filter. When you select a date in the radio button while the card is set to "Today", the card will only include rows from both the selected date AND today, which explains why you are seeing no data returned.…

@ColinHaze What challenges are you running into by changing the date filter on the card? You should be able to see different timeframes if you expand the card from the dashboard view.

@ColinHaze Could you use the card's date range settings instead?

@ColinHaze I'd suggest using the Global Date filter at the top right of your dashboard since it allows you to filter all cards by a relative date (e.g. "Today" or "Yesterday")

@VicenteS I suggest checking out the Bullet Chart type:

@Elnaz Domo's out of the box chart types don't have a stacked/grouped option for more than 2 grouped bars, though you may be able to build your own card using Bricks. That said the graph you're describing sounds like it would be pretty busy, so I would actually recommend using a simpler chart type with drills or a…

That makes sense, I didn't recognize the "CA" abbreviation