Best Of
Re: Dataset View
Views aren't scheduled to run, they're run when they're accessed. They're not materialized / saved in an actual dataset. If you're looking to materialize the view and store the contents of the view on a daily basis you can use it as an input in a dataflow and just write out the contents to a dataflow dataset.
Re: How To increase the size and change the Card title font
Hello! This is a great question. I do not believe that we have any current options to change the font/size/format of the titles of cards. However, if you wanted to follow this knowledge article, you should be able to set up your Summary number with format changes and hide your title on the dashboard. This would be a work around for your issue that I believe might work!
https://domo-support.domo.com/s/article/360043430093?language=en_US
If you want to submit a suggestion to update the product to include format changes to card titles, you can submit that suggestion here:
AKnowles
Re: How can we apply drill down functionality between two dashboards in domo?
@jaymin_63 Sadly, interactions don't work when you want to pass filters between cards and pages. I'm not sure if there's an easier way to do this, but I have been able to do this using a DDX Brick card. You can download DDX brick cards from the appstore in Domo, but they do require a little bit of JavaScript. The DDX brick cards are fully functional at setup and have JS that you can customize. I have used the DDX Map Link Navigation before and made the following update to the onClick function already in the code.
Market is the column name that I'm hoping to pass the selected value from the card to the 2nd dashboard. This is done through a pfilter, which I believe is just a page filter, like the ones that apply at the top of dashboards. As long as you have the dataset selected in the card and have the value and name selected in the DDX brick this should work!
function onClick(name) {
var openInNewWindow = true;
// Using name since that is the passed in argument for the function onClick
var link = 'https://optumcare.domo.com/page/773431254?pfilters=[{"column":"Market","dataType":"string","operand":"IN","values":["' + String(name) + '"]}]';
// console.log(name); - returns ['STATE'] - object, have to cast as String()
domo.navigate(link, openInNewWindow);
// domo.navigate('https://www.google.com/search?q=' + value, openInNewWindow);
}
jdorsch2
Re: First Word Grouping
You can use the SPLIT_PART function.
SPLIT_PART(`Name`, ' | ', 1)
This will get the first value in your string split by the ' | ' delimiter.
Re: Magic ETL Joins - include table name as prefix
@MarkSnodgrass Yep I understand, this is essentially what I've achieved with 'Select columns'. When there are 40+ columns per table and multiple tables being joined, having to rename each column makes for a slow day. It may be one for the feature suggestion then!
NateBI
Re: Report Schedule Management
Completely agree! It would also be helpful to filter by expiration date or whether the report is enabled to better manage expired reports.
Re: Why are my days of the week out of order when there is a 4-day work week?
@jperrenoud They appear to be sorting alphabetically. If you want to sort in chronological order, you can create a beast mode using the DAYOFWEEK() function and add that as your sort field instead.
Re: Dataset Naming Walkthrough Wizard
This is a great idea, even more so if it's customizable for each instance to be specific to the company needs for their naming conventions.
BCorless