Skip to main content

Salesforce - Dashboard

Few key features of Dashboard

  • Reports provide all the data shown in a dashboard. Dashboards can show data from more than one report.
  • When refreshing a dashboard, all the data-providing reports must run. If the reports take a long time to run, then the dashboard does too.
  • Dashboards are shared via folders. Whoever has permission to the folder your dashboard is saved in also has access to your dashboard. Ensure that you save your dashboard in an appropriate folder.

Filter a Dashboard

  • Each dashboard can have up to 3 filters. Contact Salesforce to increase the filter options limit in Salesforce Classic. A maximum of 50 filter options is possible.
  • You can’t add filters to dashboards that contain Visualforce or s-control components.
  • It’s not possible to filter on bucket fields. However, it is possible to use a report filtered on a bucket field on the dashboard page.
  • Filters aren’t applied when you schedule or email a dashboard.
  • You can’t filter data on a joined report in dashboard view or add a filter to a dashboard that only has joined reports.
  • You can’t use custom summary formulas in dashboard filters.
  • In Lightning Experience, relative dates (like “last month”) don’t work in dashboard filters.
  • Filters on a dashboard allow you to choose different views of data. After you filter a dashboard, the filtered view is preserved so that the next time you see the dashboard, data is filtered in the same view. Without dashboard filters, you'd have to create multiple dashboards, each with its own set of filtered reports.

Dynamic Dashboard

  • Your organization can have up to 5 dynamic dashboards for Enterprise Edition, 10 for Unlimited and Performance Edition, and 3 for Developer Edition.
  • ou can't save dynamic dashboards to personal folders.
  • You can't schedule refreshes for dynamic dashboards. They must be refreshed manually.
  • Dashboard components that use Visualforce ignore the running user; content displays only if the viewing user has access to the Visualforce page. Other components in the dashboard are not affected.

Refresh Dashboard Data

  •  The data is as current as the date and time displayed after As of... at the top right corner of the dashboard.
  • When the dashboard has finished refreshing, Salesforce 1 tells you that the dashboard is ready through the right-hand notification panel. Since push notifications aren’t enabled for dashboard refreshes, you're notified only in the app and not in through email.
  • Additional refreshes submitted during a refresh and up to one minute after the completion of a refresh are ignored; users view the most current data.
  • When you change filters on a dashboard, the dashboard shows previously cached data, if it exists. If no data exists, the dashboard fetches the latest. Either way, the dashboard’s “Last Refreshed” date shows you the timestamp for the data you’re viewing. Click Refresh to get the most recent data.
  • If your dashboard data doesn't refresh after ten minutes, the refresh automatically stops. If necessary, click Refresh again.

References

Comments

Popular posts from this blog

Product Evaluation - MuleSoft Anypoint Platform one day workshop

People, Business Executives, Enterprise Architects, Solution/System/Application Architects, Tech Leads, Developers,  who are looking for and want to know more about MuleSoft Integration offering which is compared to other key providers like Software AG WebMethods, Oracle SOA Suite, WSO2, Informatica, etc. Recently I attended a one day Workshop on MuleSoft Anypoint platform . The overall goal of this workshop was to evaluate MuleSoft integration technology offering for a mid-size integration environment which is currently supported through Software AG WebMethods and Oracle SOA Suite. So, if you are in process of evaluating MuleSoft Anypoint Platform for your integration needs, this write up will give you a good high level executive summary overview. MuleSoft Product Offering falls under following category of market offering: iPaaS (Integration Platform as a Service) Hybrid Integration On-Premise Integration Platform Internet of Things (#IOT) Integration Mule

Salesforce - Scheduling a Schedule Job

Following are the different ways to schedule a Schedule Job through a script. Run the given code in Execute Anonymous window and then you could see in Setting -> 'Scheduled Job' that your Job is waiting to be executed. Run a Schedule Job NOW Method - 1 ScheduleSalesTargets c = new ScheduleSalesTargets(); c.execute(null); Method - 2  (This one I prefer, whenever I need to run a job) Check the current Time. If it is, let's say 10:39 AM, in your clock, then set the minute to 41. This will schedule the job for 10:41 AM just two minutes from now. But, if you set minute value to 38, then it will schedule to next hour 11:38 AM ScheduleSales c = new ScheduleSales(); String sch = '0 0 * * * ?'; System.schedule('Sales Job Name - 1',  '0 41 * * * ?', c); You could repeat following, so that job keeps running every 5 minutes while you debug and change the Apex code behind the scene. ScheduleSales c = new ScheduleSales(); String sch = &#

Salesforce - Microsoft Power BI

This document outlines basic steps to install and configure Power BI with Salesforce. Usage / Highlights Retrieve User Data from Salesforce Retrieve Reports from Salesforce Read Only Access to Salesforce Connection to Salesforce is made on behalf of User. In other words, Login Session belongs to the User. Power BI utilises Salesforce OAuth security framework to connect to Salesforce Previous version of Power BI used to be Power Query, but not supported for TLS 1.1 or higher, thus could not connect to Salesforce after TLS 1.1 Security upgrade. Find details on Power Query Installation  here . Installation - Power BI Publisher for Excel Download Link  Download Power BI publisher for Excel Download for Office 64 Bit ( or 32 Bit) as needed. Close Microsoft Office Application Double click the installer file named "PowerBIpublisher_[64bit][en-us].msi" Installation - Power BI Desktop  Follow the guide as provide on this site -  https://powerbi.microsoft.com/e