ColemenWilson Coach

So does this not work for you: CASE WHEN `LOCID` IN('A','B','C') AND `flags` = 'Y' THEN 'HUB' WHEN `LOCID` = 'HWV' AND IFNULL(`PROD_CD`,'999') IN ('RSALE') THEN 'HUB' ELSE 'Not HUB' END What issue are you running into? The IFNULL isn't really necessary since you are only looking for values = 'RSALE' in your case statement.

And if you'd like you could upvote my idea to improve the email connector here: https://community-forums.domo.com/main/discussion/60745/customize-email-address-in-dataset-via-email-connector

I agree that it does not seem to change anything when enabled. My guess is that it may have to do with Brand Kit, which our instance does not have enabled. Brand Kit is a Domo paid feature that allows for instance wide branding - including colors. Perhaps when enabled users could override the default brand colors for…

Easiest thing to do is have 2 beastmodes: Current month and YTD. When the card is set to current month, only rows that match that criteria will be shown. An alternative would be to use Magic ETL to calculate the YTD value and populate it for every row in the dataset. Then, use that field in the card and just set the field…

Hello. You need to set a color rule for when Oct 23 = 'Complete' as shown similarly below:

Not that I am aware of. I would recommend submitting that as an idea in the https://community-forums.domo.com/main/categories/ideas Happy I could help!

No and the documentation is terrible: https://help.woosender.com/en/articles/6716814-integration You could look at using the JSON No Code Oauth Connector: https://domo-support.domo.com/s/article/360052105454?language=en_US#:~:text=The%20JSON%20No%20Code%20With,account%20in%20the%20Data%20Center. I don't use Woosender so I…

Gotcha, for that we use the Domostats report called "Credit Usage" and filter 'Usage Unit' to "Rows". You may not have this domostats report enabled currently, but can request it be enabled by reaching out to your CSM. This report will give you the row count over time.

Using Variables! First, create this variable: Second, create this beastmode: CASE WHEN Date Variable >= MAX(Status Start) and Date Variable < = MIN(Status End) THEN 'In' ELSE 'Out' END Third, apply the beastmode from step 2 as a filter on the card and select In = 'In' Or Not In = 'Out' Fourth, apply different dates in the…

The best way to do this is using Domogov datasets. In the connectors in Domo search "Domo" and you'll see this connector. Look for the "Datasets" report and there is a field called "Row Count". Using this field you can build cards and alerts that will help you monitor the change in rows.

If you remove all filters and sorts does it resolve the issue?

What fields do you have in the filter and sort columns?

You could explore using a variable to accomplish this: https://domo-support.domo.com/s/article/7903767835031?language=en_US

@jessdoe It's an honor to be tied for second with you!

There is a Domstats dataset that you can use to get details about all of the data sets and cards that are certified in your instance. In the connectors search for Domostats, and then choose the report for certified content.

You can create custom roles. https://domo-support.domo.com/s/article/360043438973?language=en_US You can control access to a certain dashboard using PDP https://domo-support.domo.com/s/topic/0TO5w000000Zao2GAC/personalized-data-permissions-pdp?language=en_US You can monitor if a dashboard is shared with someone it…

This is definitely possible. Configure your form to send the results to an Excel file that is in OneDrive. Then use the OneDrive for business connector to dynamically pull the data into Domo.

@AustinHarrison @nmizzell @jessdoe @MarkSnodgrass This is now an idea in the ideas exchange, please upvote: https://community-forums.domo.com/main/discussion/63582/tab-autocomplete-messed-up

I don't see anything around this in the ideas exchange, has anyone else? If not I can get it created.

Here is an example of one way to do this. Let's say you have a policy where the logic is: John Doe can only see data for the Marketing department and only data for the east region. For magic ETL you would use a formula tile and would use something like: CASE WHEN `Department` = 'Marketing' AND `Region` = 'East' THEN…

If this image below is where you are looking, then it is total count of stored rows. It believe it only updates daily. Domostats reports are your best bet for accurate row count.

You can get exact row counts using the Domostats datasets report. Dataset views are considered “virtual rows” that are considered stored rows from a credit consumption perspective.

Hmm okay. Question, if the year for the annual report is at the top of the page, first red circled "previous year" on your dashboard, then why do you need the year for each individual card? I would say best practice is to avoid adding dates in card titles, as shown here:…

You will need to create a beastmode that displays the value you want "2022". Then use the filters option for smart text. When you filter the data to 2022, the beastmode value will be 2022 and that is what will be shown in the smart text.

You could create card interactions that direct users to a full data table for export. Check out this article: https://domo-support.domo.com/s/article/360043428433?language=en_US and scroll down to "Setting Card interactions" section, specifically: "To configure specified Domo content to open when a Card is clicked"

A few questions: 1. By Q1 do you mean question 1 or quarter 1? 2. If you mean Quarter 1, is this a new calculated field? Because it isn't in your data 3. If you are aggregating there shouldn't be duplicates unless you have sorting applied which can cause duplicates even using aggregates. 4. I used your data and beastmode…

Have you looked here: https://developer.domo.com/docs/ddx-bricks And here: https://developer.domo.com/portal/ec60c4980e1b5-getting-started-using-domo-bricksscroll down to "get the data" section.

Edit the DDX brick, and select the data as shown below:

I would suggest taking a look at the calendar dataset in the Domo Dimensions connector. You can use this calendar to dynamically get the last working day of each month. Then, you could use the formula tile to assign the month groupings based on a comparison of the calendar data and your data.

You can create a beastmode (calculated field) like this: SUM(YTD_22) - SUM(YTD_23) Then drag the beastmode field into your table and it will show the difference between the two columns in your screenshot.