Best Of
PRODUCT RELEASE SNEAK: DomoStats
As an active Community member perk, we will be providing insider sneak peeks for the features we will be releasing on Wednesday May 22nd 🥳
A little bit about DomoStats: DomoStats allow users to explore insights into how their team is using Domo. DomoStats is powered by a live Domo Dataset (no configuration required!). Easily build cards, alerts, and workflows around the metrics you want to see.
We’ve got a few new DomoStats reports for this month’s release.
H2: Roles, Role Grants, & Group
With the new Roles and Role Grants reports, combined with the People report — Major Domos can see which roles are assigned to each user and which grants each user has. Major Domos can audit their users for appropriate privileges.
With the Group Owners report — Major Domos gain insight into group ownership, including ownership by individual users and/or other groups. Both of these DomoStats reports provide additional visibility and governance to your Domo environments.
H2: DomoStats: Group Members Report beta
Previously, users lacked a dataset indicating which users are members of which groups. This report will provide users with a list of groups and their members. This will help Domo Admins track group membership and can be especially helpful when combined with other DomoStats reports like the People report, Card Permissions report, and Dataset Access report.
@DanBrinton is my Product Manager for these areas and can chime in with more information and answer any questions.
Please note these features are subject to change and could lead to a delay in its deployment for an unknown amount of time.
PRODUCT RELEASE SNEAK: Alert sending Schedule Reports
As an active Community member perk, we will be providing insider sneak peeks for the features we will be releasing on Wednesday May 22nd 🥳
Both Alerts and Scheduled Reports are one of Domo’s popular features because of the automatic and valuable insights. So... imagine if we combined the power of these two features! This month’s release will introduce just that.
Scheduled Reports are just as they sound — a report sent out on a schedule, often on a weekly or daily basis. However, this frequency doesn’t always fit every need, with some users preferring to be notified only when certain changes have been made. We’ve combined the power of Alerts and Scheduled Reports to allow a report to be sent when an alert parameter is triggered, regardless of the predefined schedule. Send reports when they are needed most.
@Gavatar is my Product Manager over this feature and can chime in and answer questions.
Please note these features are subject to change and could lead to a delay in its deployment for an unknown amount of time.
Re: can anyone point me to the solution on how to build the following year to date vs previous year?
Final version, Working
May 2024 Domo Release
If you logged into Domo today, you should have seen a preview of the new features and enhancements and betas coming to Domo next week. As I started doing earlier in the year, posting a PDF here since those messages disappear
once you read them. Enjoy.
Re: Displaying How far ahead or behind goals as weeks progress
The easier approach is to use Domo's built in chart type "Running total grouped bar".
If you want to use the chart properties option, you'll need to use a line/bar combo chart. Then you can set the series on left scale to 0 and set number of running bars to 2. I don't see much advantage to this approach given your use-case. This is better if you want to have both individual and running total on the same chart.
Re: Drill Down Selector
Do a search on community forums for "pfilter". You should find some examples of passing parameters.
Re: Current day vs same week day last week
You could do something like this:
CASE WHEN `Date` >= DATE_SUB(DATE_FORMAT(curdate(), '%Y-01-01'), INTERVAL 1 YEAR)
AND `Date` <= DATE_SUB(curdate(), INTERVAL 1 YEAR)
THEN `Revenue`
END
This would return the revenue when it was between Jan 1 last year and current day last year.
Let me know if you need anything else,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
Any Way to Report on Column Usage in Cards
We are trying to filter out unnecessary and unused columns from our datasets and it would be really useful to be able to create a DomoStats or Governance report that shows which columns are used on cards and which are not used at all. Is there any way to do this?
pstrauss
NEW COMMUNITY COACH: @david_cunningham 🔥🥳
Huge shoutout and congratulations to @david_cunningham for hitting Coach status on the Community Forums!
David joined the Community Forums just ONE month ago! He ranked up from Member ➡️ Coach faster than any user in the history of the Community! Go David!
In the month of May alone, he has answered 62 questions — this is more than half of the questions asked this month (and we aren't even halfway through May yet).
Please take a moment to thank and congratulate David for all his help and "Coach" expertise in the comments below. Don't forget to tag @david_cunningham 🙌🏻
Re: Filter in magic ETL
Thanks @david_cunningham and @Sean_Tully . I actually have both cases one without the rank and another one with rank, so thank you both for the insightful answers. I was able to filter the data.😃
vaco