In Winter 22 release, Salesforce releases Dynamic Gauge Charts in Dashboard, even still beta. Before this, all segments (low, medium, high) values must be entered manually by editing the component. With Dynamic Gauge Charts, you just need to update a field and the segment target changed.
To use Dynamic Gauge Chart, you need to enable the feature from Reports and Dashboards Settings in the setup menu.
The concept
You need to have a target value, this is the max value of the gauge chart. The value should be defined in an object, within a record, and in a field. Let say you use the Opportunity report for the component, it does not make sense to put the target in the Opportunity object.
So, here is my idea:
- Create a custom object
- Create a number field: this to store the value or target
- Create a text field: this field used to store description
The component
Once "Enable Dashboard Dynamic Gauge Charts (Lightning Experience only)" is enabled, you will see Mode: Standard and Dynamic when editing a Gauge component. Standard = existing mode where you need to enter values for each segment, while Dynamic is the new one, where the segment is divided by % of target.
Record = which record that holds the value for this component
Field = which field from the above record holds the value
Instead of value as per normal, we need to enter % for each segment to divide segments of the low, medium, high.
Footer: once you select "dynamic" mode, you cannot make use of the footer by entering any text, it will be locked and will show the description, for example, Sum of Amount (USD) compared to Target (Dynamic: Rec-1)
- Sum of Amount (USD) = the needle of gauge chart, which is the current value in the database
- Target = field name
- Dynamic = object name
- Rec-1 = record name
Reference:
IS this dynamic? So if I update the Dashboard filters, would the dynamic gauge update to a new record?
ReplyDeleteunfortunately not, the target only make sense for dashboard without filter, although it still work. I cant think of how is the business case for that.
DeleteWhat permissions are needed for users to be able to view the dynamic gauge. My users get an error when trying to view it. When I give them manage reports and dashboards I don't see the error any longer. Thanks!
ReplyDeleteThere was issue in the past release, but it has been fixed many months back.
DeleteNo extra permission is needed for normal user to access the dashboard.
We discovered that the "Create and Customize Dashboards" permission is needed for users to access dashboards that use Dynamic Gauge Charts. I just created an Idea on the IdeaExchange for this to be fixed: https://ideas.salesforce.com/s/idea/a0B8W00000H65yJUAR/dynamic-gauge-charts-create-and-customize-dashboards-permission-requirement
Deletemy users can use dynamic gauge dashboard without the need of the "Create and Customize Dashboards" permission
DeleteHmm does another permission that you have turned on go beyond this one then to open up this access? Confirmation that "Create and Customize Dashboards" is necessary came from Salesforce after I opened a Support Ticket.
DeleteI just try in my prod, it works without the need to have "Create and Customize Dashboards". But when try to re-setup in a DE org, I get the error "invalid cross reference id" not sure what happened in my prod, but it was an issue in the past, until I reach with the PM.
Delete