Make Your SFDC Dashboard More Versatile With Filters

[vc_row][vc_column][vc_column_text]marketing-2-dash-dashboard-filter
While Marketo offers a rich set of reporting functionality many organizations want Salesforce.com to be the go-to system for sales and marketing dashboards. Rather than create a separate dashboard to show Monthly, Quarterly, or Yearly data, use a SFDC dashboard filter to create one dashboard that works for all time periods.

The dashboard supports filtering by time period, so report information can be viewed by Month, Quarter, or Year.[/vc_column_text][edgtf_separator type=”full-width” color=”#f2f0e4″ border_style=”dashed” thickness=”4″ top_margin=”18px” bottom_margin=”18px”][vc_column_text]

Creating SFDC Dashboard Filters

marketing-2-dash-sfdc-filters
SFDC supports up to four filters on a dashboard. For example, the following filter shows a SFDC dashboard filter for Time Period.

Filters can be created while in the Dashboard “edit” mode when you click on the “Add Filter” button, which opens the following dialog:[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_empty_space height=”40px”][/vc_column][/vc_row][vc_row css=”.vc_custom_1477333131309{padding-top: 40px !important;padding-right: 20px !important;padding-bottom: 40px !important;padding-left: 20px !important;background-color: #f2f0e4 !important;}”][vc_column][vc_column_text]

Dashboard Filter Rules of the Road

[/vc_column_text][vc_empty_space height=”30px”][vc_row_inner][vc_column_inner][edgtf_separator type=”full-width” color=”#babf33″ border_style=”dashed” thickness=”4″ top_margin=”18px” bottom_margin=”18px”][vc_column_text]

The Marketing 2.0 Dashboard requires the following architectural settings:

[/vc_column_text][vc_empty_space height=”24px”][edgtf_icon_list_item icon_pack=”simple_line_icons” simple_line_icons=”icon-check” icon_size=”18px” icon_color=”#babf33″ title=”Date fields used for the dashboard filters must be Datetime fields. Salesforce.com and Marketo system fields use Datetime, and are also common fields to use as filters (Create Date, Modify Date).” title_size=”18px” title_color=”#3f3215″][edgtf_icon_list_item icon_pack=”simple_line_icons” simple_line_icons=”icon-check” icon_size=”18px” icon_color=”#babf33″ title=”All reports should default to All Time or THIS YEAR date ranges.” title_size=”18px” title_color=”#3f3215″][edgtf_icon_list_item icon_pack=”simple_line_icons” simple_line_icons=”icon-check” icon_size=”18px” icon_color=”#babf33″ title=”All dashboard components should default to “Use chart type as defined in source report” = TRUE.” title_size=”18px” title_color=”#3f3215″][edgtf_icon_list_item icon_pack=”simple_line_icons” simple_line_icons=”icon-check” icon_size=”18px” icon_color=”#babf33″ title=”New SFDC fields: MQL Date (lead and contact), MQL Latest Date (lead and contact), Disqualified Reason (lead and contact), SQL Date (lead and contact), SAL Date (lead and contact).” title_size=”18px” title_color=”#3f3215″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]