ColemenWilson Coach

You can filter on aggregates. So the field you are using to calculate the bars can be added as a filter using the same aggregate (sum, max, avg) and you can set the filter to anything greater than 0.

You can use that and other date functions using a formula tile.

Yes this is possible. You can do it using the Group Management tool in Governance Toolkit. Group Management tool lets you use any logic from any data to create your criteria for a group:

@Manasi_Panov sure thing!

You can in an HTML table, not sure about in Pivot table. See here:

You could make them a social user and prevent them from logging in to your instance. Be sure to disable "Welcome to Domo" emails from your instance. They should still receive alert notifications. Keep in mind that alerts have a "View Alert" button at the bottom of the email which would prompt them to login - just something…

The best way to do this would be in an ETL. Because the cards/dashboards have different filtering, it makes the most sense to have two paths from the input dataset in MagicETL: 1. with the filtering/logic from dashboard 1 and 2. with the filtering/logic from dashboard 2. Then you can do an inner join on email which will…

You could look at using a private/public embed and then provide a link in an email. Emails can be scheduled via your email provider and the link, because it is a link to live Domo content, would always have the updated data.

You can get this format easily and by default using a dataset alert rather than a card alert:

Also, what if you scrap this ETL and instead convert your string to date in a beastmode? Using STR_TO_DATE() or I guess the same formula you are using in your formula tile?

I am guessing something else is happening in your dataflow unrelated to the alter columns tile because casting the data type in the alter columns tile shouldn't cause the output you are seeing. What else is going on in your ETL? Is it just what you screenshot above? The second line (-43,413.64) going to -41,412.00 makes no…

I am having the same issue in my instance. I would do what I've done and submit a Domo Support request.

Could you provide a bit more information and perhaps a screenshot of your analyzer view? Also, you may want to take a look at the Domo Profit & Loss (P&L) app in the Domo Appstore:

Try switching to floating decimal instead of fixed.

Can you share a screenshot of your analyzer view? For your second question, I would a multi-value gauge card. I like using these to show a single variance between two values. Your beastmode should work, you need to include year in your beastmode logic as well or else values from other years would be included.

Yep! If it increases by at least 1 it will trigger. So from 0 to 2 will trigger the alert.

Would changing it to Summary number increases by 1 meet your needs?

Do you have any sorting applied to your card? Is your field set to some kind of aggregation like Count? It would be helpful if you could include a screenshot of your analyzer setup.

I am seeing annotations on my dashboard PDF exports. I am also seeing them on scheduled reports. I am not seeing card descriptions on either. I would double check your annotation settings and perhaps reach out to Domo Support if you are still not seeing them.

MAX(CASE WHEN all of your other logic AND yourDateField <= LAST_DAY(CURRENT_DATE()) - INTERVAL 1 MONTH AND yourDateField >= LAST_DAY(CURRENT_DATE()) + INTERVAL 1 DAY - INTERVAL 2 MONTH THEN your other logic END

Whenever the dataset powering the card with the NOW() function updates the current time will update. So you could set the dataset to update every 15 minutes to get more updated time.

Oh interesting, I thought your values were just: 2023, 2024, etc… I didn't realize they were in date format. Could you provide a screen recording of what you are seeing along with the underlying fields?

Romania and Albania!

I am unable to replicate this issue. I would recommend submitting a support request to Domo Support.

Try creating a beastmode for the field that has the 2,024 value: yourField * 1 And then use that as the filter for the card and the comma should disappear. Another option is: REPLACE(yourField,',','') The other option is to change the data type of the field in Magic ETL to an integer.

@ellibot did a demoslam at Domopalooza this year on conditional rendering that you may be able to use accomplish this. Was the demoslam recorded @Eddie Small? If not, hopefully Elliott can help ya out!

You can do this with quick filters. Click Select All for the quick filter in analyzer view and then save the card. All data will still be shown and once one is selected, it will filter for that value.

Yes, but does it differ at all from a normal card view? Is there a way to know that it was viewed in excel?

Did some testing here and the closest you can get in the activity log is to look in the Browser_Details field. I believe there will be a unique (or unique-ish) value there for this type of activity. You could look for that exact match or may notice a pattern if you have a few users doing this it will likely be a similar…

Yep! You can use the "Cards and Datasets" report from the Domo Governance Datasets connector. This will give you every card and its associated dataset. You can then use the activity log report from Domostats connector to group the total views by card ID and then join with the Cards and Datasets dataset on Card ID. You…