ColemenWilson Coach

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.

Last Week: CASE WHEN WEEK(`DateField`) = WEEK(CURRENT_DATE())-1 THEN 'In' ELSE 'Out' END MTD: CASE WHEN `DateField` > LAST_DAY(CURRENT_DATE()) - INTERVAL 1 MONTH AND `DateField` <= CURRENT_DATE() THEN 'In' ELSE 'Out' END QTD: CASE WHEN QUARTER(`DateField`) = QUARTER(CURRENT_DATE()) AND YEAR(`DateField`) =…

Yes! There is a Domo Governance dataset report called "Datasets" that has a field called `Type` that has this information. You would filter the data using the `Type` field to show only datasets who have Big Query as a source. The issue you will run into is dataflows. A dataset could have data from a Big Query data source…

In my experience with this connector, you can only see the Microsoft account logged in through Domo. We created a service account in Domo specifically for this purpose, and have a process to share content with that user in Microsoft so that it can be utilized in Domo. So I don't believe you would be able to see all emails…

Have you looked into the Domo for Office PowerPoint add on?

The DomoStats Dataset History report has a field called `Bytes Inserted` that could be used as well.

Hello, this knowledge article walks through instance time zone setting and how they affect dates:

You would use magic ETL. Use the group by tile and create max and min values. You could also use the formula tile and use MAX() and MIN(). You could also use a beastmode in a card and use MAX() and MIN(). There is also a calendar chart type. This knowledge article walks through how to use them:

Good catch @MarkSnodgrass, I was looking at it on my phone and the ticks appeared to be ' not `

Is there a particular reason you need them to be null? If they are numeric values you can set them to = 0 and if they are strings you can set them to = ‘’ it looks like you are working with percentages, so could you just set it to = 0?

Hmm maybe just eliminate line 3 and replace it with ELSE ‘’

Just use THEN ‘’ END