Best Of
Re: Drill Path - working in Edit Drill path, not working in pages
@Laura_M1 Is the second level detail you're trying to see defined as a drill layer in Analyzer or the default "Data" view? If it's the latter, then drilling to it is only an option on from the card details view and not from the dashboard. In that case I suggest adding a Table chart drill layer so that it is visible when drilling from the dashboard
Re: STR_TO_DATE
@RayRay_H It looks like there may be a space after the date in the error message. Try replacing the spaces with an empty string before using the STR_TO_DATE function
STR_TO_DATE(REPLACE(`Date`,' ',''),'%d-%b-%y')
Re: Auto Export CSV File
Yes. Scheduled Reports have the option to attach a CSV file to the email.
Re: In-Dashboard Navigation Options.
Agree, there needs to be a way to paginate / break dashboards up into navigable pages. I thought the subpages function would handle that, but it doesn't seem to have any function other than to organize your dashboard pages.
You can use links and link to content, but that gets clunky fast for Domo Everywhere users who don't have full access to the platform.
Re: I want to create dashboard with a form in domo.
Sure thing:
- Copy the embed code from the Microsoft Form
2. Download from the Domo Appstore: HTML Easy Brick
3. Edit the HTML Easy Brick, paste the embed code in the HTML section
4. Save and close
5. Use the OneDrive for business connector to pull the form results into Domo
Keep in mind that all that is happening is that the form is being embed in Domo, all form settings still need to be set in Microsoft.
Period over Period and global date selector
Hi,
I have noticed if you have any period over period charts in the dashboard and on the global date selector you select a between x date and y date all period over period charts and widgets stop their comparisons to the prior periods. Is this normal?
Thanks
Paul
Jones01
Re: locks = locks?
Perhaps not the best way, but to your ETL that builds that DataSet, I'd add a calculated column that tells you the difference between the 2 values and another one that would just flag if the date is older than your threshold (in this case 7 days).
You'll have a formula tile in your ETL that will do both calculations, something like
IsOlderThanThreshold
CASE WHEN `PowerLenderLockDate` <= CURDATE() - Interval 7 Day THEN 'True' ELSE 'False' END
Delta
Rate_locks_powerlender - Rate_locks_powerseller
With this I'd then do the Alert as follows:
- Trigger Depends on whether your ETL does replace or append.
- Filters
- IsOlderThanThreshold equals True
- Delta is not equal to 0
This has the advantage that it won't only notify you when the entry 0 days ago is not 0, but whenever an older entry may stop being compliant. Hope this helps.
