Best Of
Re: Finding average of difference in two different dates
Since you're doing a windowing function have you looked into the Rank & Window tile?
Re: Getting an error in visualizer
What I've done when I encounter this is open a new browser window and use the non-saving card as a guide to build the card again in the new window. This isn't perfect but helps you rebuild the card again much faster.
It may also be worth adjusting settings on the card one at a time and saving after every step. If my memory is correct, adjusting the timeframe in the top right of the card has sometimes been what's stopping the card from saving for me.
Re: data flow to added new data to dataset each week.
currently the only supported method is to do a recursive dataflow.
You can read up on how to do them here: https://domohelp.domo.com/hc/en-us/articles/360057087393-Creating-a-Recursive-Snapshot-DataFlow-in-the-New-Magic-ETL
You can also talk with your CSM if there are any other options for you to opt into
Access to Domo Community Instance
In order to enable our community members to better share ideas and collaborate, we have provided a Domo instance that is only available to community members and is managed by community members. This instance has access to features that may not be available in your own instance, including beta features, for you to take for a test drive. In addition, user group speakers often build out their solutions that you can test in the instance.
Please be responsible in using this instance and follow these guidelines:
- Treat everyone and everything in this instance with respect.
- This is everyone’s sandbox, don’t abuse it.
- Assume all Data in this instance is public. Don’t upload private or sensitive data.
- Domo reserves the right to ban members and/or close down this instance if there is improper use or abuse.
In order to gain access to this instance please reach out to beta.admin@domo.com with your request.
Best,
Domo Community Team
Re: How to display results up to last week
@MarkSnodgrass Understood, thank you for sharing!
Re: How do I create a rate with 1 row of data then filter it by unique cells of another row?
For your percentage of patients admitted via observation, you can use a beast mode like the following:
SUM(case when 'Enc status' = "Observation" then 1 else 0 end)/COUNT('Enc status')
This will get you the total observation patients divided by the total patients. To get it broken out by provider, you can just let Domo do the work. If you do a table and put the providers as a column, or a chart with providers on the axis, you can use your beast mode as your other column and it will just do the calculations for each one.
Ranking up in the Community Forum
What is a rank?
Rankings are a reflection of activity and engagement in the Community Forum. After registration and your first time signing in, you will be a Member.
As you answer questions, earn badges, and receive reactions, you will accumulate points. The more points you have, the higher rank association you earn.
Members who reach the Coach level receive special privileges in the community forums and beyond.
Rank structure:
Member [0 points]
Contributor [100 points]
Coach [1000 points]
Re: How to display results up to last week
The script you gave me helped me accomplish what I wanted to do!
Thank you! It will be a great learning experience.
Re: How to display results up to last week
You can create a beast mode that will look at the current date and then move it back to the last day of the previous week and then compare it against your date field.
CASE WHEN `date` <= /* last day of the previous week */ DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK) , INTERVAL (7- DAYOFWEEK(CURRENT_DATE())) DAY) THEN 'Include' ELSE 'Exclude' END
You would then drag this beast mode into your filters section and select Include.
