Best Of
Re: Case Statement - 28 Days from a specific date?
@dlc3 Amazing solution! Going to be using this for sure!
Re: Anyone else wanting to join to the same table multiple times in a view?
You could make duplicate views and bring those in as additional datasets to join twice more.
Re: Syntax Error in Beast mode calculation
Colemen's answer will give an empty string instead of a NULL. If you want a NULL, then you could flip your CASE statement. Everything that is not "not 1" will be NULL:
CASE
WHEN Sort: Month Number != 1 THEN
(
(SUM(All Cases) - LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number)) /
LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number)
)
END
Re: ETL Wont let me 'Edit' then 'Run'
@DavidChurchman & @ArborRose
No idea what the issue was. Without making any changes it now works. Guess it was just throwing a fit lol.
Re: ETL Wont let me 'Edit' then 'Run'
There appears to be something in the ETL that isn't valid. Perhaps it doesn't have a output tile or something?
Re: ETL Wont let me 'Edit' then 'Run'
I would look at your History to see if it's truly running when it says its running. Also, double check your Versions. What was the difference between the last version and this one? Do you have anything unconnected in the ETL, maybe hiding in some corner?
Re: Change Dataset on Form and Dataset Brick
I believe to change the dataset that your brick is connected to, you'll need to adjust the configuration within the brick itself. Open the configuration settings and look for the option where you specify the dataset that the brick is connected to. This is labeled as "Dataset" or something similar.
Sorry, I'm not currently where I can look at it.
Re: Change Dataset on Form and Dataset Brick
The Form and DataSet Brick uses a form inside of the app to write to AppDB. AppDB is a document based data system that is separate from the standard DataSets found in Domo. This AppDB data can be synced to a standard Domo DataSet. The DataSet it syncs to is automatically generated with a name using the format {collectionName}_{appInstanceId}_APP_DB. You can change this name in the DataCenter once the DataSet is generated.
Now, if you want, you can link this DataSet to the app and perform queries or whatever you need with it however, since this app is already writing to AppDB you can just make queries to AppDB instead and not need to use a synced DataSet at all. The table shown with the default Brick code is pulling from AppDB so it won't reflect anything being changed with the wired DataSet only the wired collection.
Re: Public embedding of a dashboard
Here is a loom video on how to make sure everything is enabled:
Follow these 3 steps:
1. Make sure you have "Allow public embedding of Cards and Dashboards" checked.
2.) Add your domains like "https://*.yourcompany.com" and "https://yourcompany.com" added to approve domains.
3.) Embed the public iframe like so:
<iframe src="https://public.domo.com/embed/pages/g5K5r" width="1248" height="1620" marginheight="0" marginwidth="0" frameborder="0"></iframe>
Hope that answers your question!
Re: Group Administration
If you are an instance admin then you control all grants. Grants are controlled in the Roles section in Admin settings.
EDIT: oh I was able to replicate the issue you are having. Yikes that seems like a product enhancement need. I would suggest submitting this in the ideas exchange
You can also modify the group using the Group Management tool in governance toolkit: