ColemenWilson Coach

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 Happy I could help!

No and the documentation is terrible: You could look at using the JSON No Code Oauth Connector: I don't use Woosender so I don't have a Client ID and Secret I could use to test. Good luck!

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:

@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. You can control access to a certain dashboard using PDP You can monitor if a dashboard is shared with someone it shouldn't be using the Pages and Users Domo Governance dataset.

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:

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 could make the first single value card at the…

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: 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: And here: scroll 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.

This is possible in magic ETL. Use GROUP_CONCAT() or the group by tile to achieve this. The first step would be to filter the data to unique values and then group concat Field C with Field A as the partition in the case above.

Oh no, that would not be secure at all. All we are looking for is a view as user or view as role - "view" being the key word.

Re-read your initial question - you would need to do some work in ETL as @jessdoe pointed out. You can re-purpose your beastmodes to save time. Just use the formula tile in magic.