Best Of
Re: Business Glossary
Another feature that would be helpful to include in this is the ability to search for columns, select some or all that have the same name to add a link and/or common description to them.
Re: Period over Period Beast Mode
Hello @MarcusJ223
I'd suggest taking a look at this KB Article:
Particularly the Calculating Variance Variance CY-PY and Variance % ((CY - PY)/PY) as these sound like what you're looking to accomplish.
From the article:
Calculating Variance — Variance CY-PY
Use the following code to create a calculation for the variance Current Year - Past Year:
(
SUM(CASE WHEN YEAR(`MyDateColumn`) = YEAR(CURRENT_DATE()) THEN `Amount` ELSE 0 END)
- SUM(CASE WHEN YEAR(`MyDateColumn`) = YEAR(CURRENT_DATE()) - 1 THEN `Amount` ELSE 0 END)
)
Variance % ((CY - PY)/PY)
Use the following code to create a calculation for the variance % ((Current Year - Past Year) / Past Year):
(
(SUM(CASE WHEN YEAR(`MyDateColumn`) = YEAR(CURRENT_DATE()) THEN `Amount` ELSE 0 END)
- SUM(CASE WHEN YEAR(`MyDateColumn`) = YEAR(CURRENT_DATE()) - 1 THEN `Amount` ELSE 0 END)
)
/ NULLIF(SUM(CASE WHEN YEAR(`MyDateColumn`) = YEAR(CURRENT_DATE()) - 1 THEN `Amount` ELSE 0 END), 0)
)
Re: Missing “Create App” Option in App Studio for Specific Users
Do you have the same role with the same permissions? The permissions for apps are split in two places, under DomoApps and "Cards and Pages", so it's possible your admin missed the second part when assigning permissions to the role missing access to App Studio (speaking as an admin who did exactly that).
Re: Is it possible for two people to have admin access to the Domo Workbench?
@RacquelBeer @GrantSmith - the new Workbench Enterprise feature (currently in beta) can be a great solution here:
Workbench Enterprise is a web-based alternative to our existing on-prem Workbench solution that includes powerful new capabilities.
FEATURES
- Multi-user access to your pool of Workbench jobs
- Web-based—allows for remote management of Workbench on different platforms/browsers while web-server remains on-prem
- Multi-platform on Linux, Windows, and MacOS
- Split up large jobs between worker nodes on the server
If you are interested in joining the beta, we can for sure get you added!
Re: Data Export an Embedded App Question
@Jones01 Each of our clients has a dedicated instance of our platform that works exactly like logging into DOMO. For example, ”companyname.domo.com”. They are prompted for their employee email and their password, and if all of the authentication checks are passed they are logged into their instance of our app and can use it and its functions. If a client tried to login to an instance other than theirs by changing “companyname” and trying to log in, they are automatically redirected to their instance. One of the links within our app opens the public embed link to the Domo dashboard within an <iframe> where they can interact with it. If someone who already had the credentials wants to inspect the source code to find the public embed links for each page of the dashboard, then they can do it. We don’t use PDP row filters and once you have the embed link, you can’t do anything more with it than you could when it was in an iframe. The customer provides us with the data and we make a dashboard out of it and provide it to the customer. They can do what they choose to do with their data at that point. The only way someone could access the public embed link would be to typing in random DOMO embed links, and if a link to one of our dashboard reports was found, it would be one of thirty for a single company. The reports themselves don’t contain the navigation to get to any of the other DOMO reports for the same company. The data contains no PHI or HIPPA related data. I asked the same questions you are asking when I started working. I also spoke to someone at Domo last night and they confirmed that the public export option for apps is being talked about, but no firm plans or date yet.
pshull
How do you apply color rules to subtotal rows in a chart?
I created a chart with color rules based on calculated fields, but my subtotal and grand total rows didn't change color. How do I get the color rules to apply to my subtotal and grand total rows as well?
Re: Dynamic Chart Height
would love an update on this, We roll out boards to multiple clients and some of the table cards have a ridiculous amount of white space.
Jones01
Re: Having Multiple Group By tiles?
@TC1199A you will have to combine the data either by APPEND or JOIN depending of your needs.
Godiepi
Re: Time Difference in Minutes
You can simplify your beast mode. If either of your fields are NULL then the entire subtraction will be NULL.
(UNIX_TIMESTAMP(`Hospital Ready Time (UTC)`) - UNIX_TIMESTAMP(`Video Start Time (UTC)`)) / 60
