Best Of
Dashboard Layouts - Control Padding Between Cards
Currently, there is no way to adjust the padding between cards. This can often result in information being spaced out and very aesthetically pleasing. As an example, these gauges end up having a lot of space between them. It would be nice to be able to have a way to control how much padding is being applied.
Scheduled Report - Excel Attachement
Allow scheduled reports to attach the data in excel format rather than csv. CSV files don't keep special characters in the data, so accented characters are messed up in the CSV.
mberkeley
How to Create Multiple Summary Numbers
Issue/Business Problem Description
Many customers want to display multiple card summary stats that can give them a better picture of what’s going on in the card as it helps tell the story and can highlight what the card has in it.
Description of Solution
A customized Beast Mode calculation is necessary. The “secret sauce” is the concat() function as you can add in text, and any combination of metrics inside the concat() statement. One thing to note is that this bypasses formatting options so they will need to be built into the concat() statement.
BEAST MODE LAYOUT: concat(calculation,‘ Text’, etc)
All examples below are based off of demo data.
EXAMPLES:
LOOKS LIKE:
BEAST MODE: concat(# calc, text, # calc, text)
concat(Sum(CASE when `Status` <> ’New' then 1 END),' Total, ',sum(case when `Date` >= date_sub(curdate(),INTERVAL 1 MONTH) then 1 else 0 end),' In Last 30 Days’)
________________________________________________________________________________
LOOKS LIKE:
BEAST MODE: concat(# calc, text, # calc, text, $ calc, text)
concat(SUM(Case when (month(`Date`) = month(curdate()) and year(`Date`) = year(curdate()) and `Opportunity_Type__c` = 'New') then 1 else 0 end),' New, ',SUM(Case when (month(`Date`) = month(curdate()) and year(`Date`) = year(curdate()) and `Opportunity_Type__c` = 'Upsell') then 1 else 0 end),' Upsell - $',round(SUM(Case when (month(`Date`) = month(curdate()) and year(`Date`) = year(curdate())) then `Amount` else 0 end)/1000000,2),'m’)
________________________________________________________________________________
LOOKS LIKE:
BEAST MODE: concat(text, $ calc, text, html image, # calc, text)
concat('$',round(SUM(Case when (`Contracts__r.Date__c`<= curdate() and `Contracts__r.Status__c` = 'Accepted' and `Account.Account_Status__c` = 'Active') then `Amount` END)/1000000,2),(case when round(SUM(Case when (`Contracts__r.Date__c`<= curdate() and `Contracts__r.Status__c` = 'Accepted' and `Account.Account_Status__c` = 'Active') then `Amount` END)/SUM(Case when (`Contracts__r.Date__c`<= date_sub(curdate(), INTERVAL 1 MONTH) and `Contracts__r.Status__c` = 'Accepted' and `Account.Account_Status__c` = 'Active') then `Amount` END)-1,2) > 0 then 'm - ? ' else 'm - ? ' end),round(round(SUM(Case when (`Contracts__r.Date__c`<= curdate() and `Contracts__r.Status__c` = 'Accepted' and `Account.Account_Status__c` = 'Active') then `Amount` END)/SUM(Case when (`Contracts__r.Date__c`<= date_sub(curdate(), INTERVAL 1 MONTH) and `Contracts__r.Status__c` = 'Accepted' and `Account.Account_Status__c` = 'Active') then `Amount` END)-1,2)*100,0),'% From 30 Days Ago')
scherbelr
Fiscal calendar - select like other date-related filters, bulk enable on cards, apply to beast modes
We want to use custom fiscal calendars in our subscriber instances, so our customers can have their fiscal calendars. However, a few limitations of the fiscal calendar in its current form will prevent this from being useful for our published content.
- We want users to be able to choose if they want to view a visualization by fiscal or calendar year without needing to go into Analyzer and modify the card. I think the fiscal or calendar year selection should be in the same place where an end-user can change the date range of the card on the fly.
- We must enable the fiscal calendar on a card-by-card basis. If we did implement this for our published content, we would need to change over 1,000 cards individually.
- Finally, the beast mode limitations related to fiscal calendars are an issue for us. I upvoted the Fiscal calendar should apply to beast modes idea to cover this need.
So, to summarize items 1 and 2, we'd like to have the ability to enable the fiscal calendar across cards in bulk. Once enabled, consumers of the card that do not have Edit permissions would be able to interact with a fiscal/standard calendar selector just as they can with other date range filters.
akeating
Card Analyzer - Date Filter Options
When building charts, especially trend charts or period over period charts it would be helpful if we had the option to include the "Current" day. It is not a fair comparison (even for WKTD) looks if the current day is a partial day and the last week to day was a complete day. If the option for last completed day or penultimate day was available that would help build charts without needing a beast mode calculation.
buzz_boom
Domo Certification progress and Community Engagement Datasets
related to https://dojo.domo.com/main/discussion/55623/dataset-card-certification-history
it would be ideal if Domo could provide datasets that would allow us to track user behavior in the community oriented resources (KBs, updates in Dojo, Support tickets, and Domo Certification / mdoule completion).
As Domo Champions roll out training and enablement inside enterprise accounts it would be ideal to have visibility on which users are pursuing enablement opportunities. These might become our future Domo Champions and Major Domos.
jaeW_at_Onyx
Re: Rank based on 2 metrics?
In your OVER clause, you should be able to add ORDER BY and list current run DESC, total current run DESC so that it will sort by current run first and then total current run after that.