MichelleH Coach

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

@Harganz01 If the dataset has been run in Domo, then the History tab should not be blank. I'd suggest reaching out to support with a link to your dataset to look into it further.

@ColinHaze You can also try using the %_PERCENT_OF_CATEGORY macro in the Hover Text. There is also a an option for percent of total.

@Patrick_Cruz You can choose which columns you want to have centered by clicking the pencil icon on the pill for that column. The setting is under Format > Justification

@Alex_K You can do this by adding HTML to your metric in a beast mode like this: case when `Sales` > 0 then concat('<div style="color: #f00">',`Sales`,'</div>') else concat(`Sales`,'') end Here is a knowledge base article on how that works:

@lbg3222 Here are a couple things I can think of: Verify that your connector is set up to look for a CSV file type Verify that you included the "\.csv" in the attachment name expression

@lbg3222 You can use regex in the Attachment Name Expression field to specify which file you want to import. If you want to keep the file that ends in "Statement.csv" then you can use this: .*Statement\.csv The ".*" at the beginning acts as a wildcard to allow any date prefix.

@nmizzell @MarkSnodgrass I've noticed that hitting "Enter" to autocomplete still works as expected. Does it work the same for you?

@Marie_Serrano That's odd. I'd suggest rebuilding the alert to see if that resolves the issue. Otherwise you may need to reach out to Domo support to look into it further.

Agreed, I have been encountering the same issue in both instances using Chrome/Windows 10. I will have to test whether it works as expected on other browsers or operating systems.

@Marie_Serrano When did you create the alert? If you created it after 9:10 EST today, then it has not checked whether the summary number meets the threshold. You can test this by changing the time to later today to see if it triggers the alert.

@SayyedHussain If you want to prevent new members from being added to groups, change the group from an Open Group to a Closed Group so that new members can only be added by the owners.

@ColinHaze There are a couple different options you could use: You can reach out to your CSM about enabling a fiscal calendar in your instance. Here is a knowledge base article about how they work: You can upload a file to Domo with a row for every date and its corresponding month. Then you can join your data to that…

@damen I agree with what the others have said. If you have a numerical field with the actual housing price in your dataset, you could also sort by the average of that field.