The most important thing to know is what the Business Users most need to grok at a glance. For Membership, Development and Consulting its where we are in terms of revenue.
- What’s been booked
- What the $ goal is
- Are we on track to reach our goal
- What’s the pipeline health
The data visualizations should:
- Be clear and understandable at a glance
- Have clear criteria reflected in a good title
- Have a clear time frame reflected in a good title
- Current Membership Campaign
- Membership Campaign Performance year over year
- Current Development Campaigns
- Consulting Revenue and Pipeline
Salesforce allows the assignment of colors to values for picklist values only. Look to see what you can leverage here. Method used: systematic survey of key picklist field types. Note what looks promising. Then survey non-picklist fields for ideas of what you want to include in dashboards to consider pushing into picklists via workflow rules or process builder.
You may want to sketch these out to see if they might be promising before investing the time in creating custom fields and workflow rules/process builder processes.
I experimented with creating an Opportunity Year picklist field and used workflow rules to populate past year historical opportunity data. I have an ongoing Process Builder process handling opportunity data going forward. This took about 4 hours of work including running Demand Tools to Mass Impact update my Mass-Update__c field with a date to edit the records of interest in order to bulk update them. I have now transitioned over to useing Opportunity_Year__c in place of my bucket field for Membership year. My years now have consistent color assignments in dashboards.