Permission settings or the dimensions pulled into your dashboard questions can impact the values you or your team see when working in dashboards. This article outlines common causes of dashboard values not tying out and will help you correct them.
Team members have limited data permissions
If you see lower values than expected, or if you and a colleague see different values in your dashboards, it may be due to a permissions issue.
When a team member has limited access to dimensions in Cube, any dimensions they are disallowed from will be excluded from their view in Dashboards. This applies to raw values and aggregations for team members building or viewing any dashboards.
For example, the team member with the permission set outlined in the image below won't see personnel expenses when working with dashboards.
If permissions need to be changed, Cube Admins can update them anytime. Learn more about managing team permissions.
Calculated values need to be accounted for
If you see higher values than expected, it may be because tags or formulas included in the dashboard question are causing duplicated values.
When these different value types are mixed together in a visualization, it can result in an inflated sum.
To resolve this, edit the dashboard question to add the filter called Calculated and set it to False. This ensures you are calculating with input values only.
Learn more about how to account for tags and formulas when building dashboard questions.
A dashboard contains an incompatible formula
If you see lower values than expected, it may be because a formula dimension used in the dashboard question isn't compatible with dashboards.
If the formula dimension relies on the roll-up logic of Sum leaf values, then calculate, it cannot be directly plotted in dashboards by adding the dimension as a filter.
These formula dimensions don't store values directly; they are calculated as they are fetched. When used in a dashboard question, this type of dimension will contain a null or zero value.
Instead, construct your question by making sure the individual dimensions that make up the formula are captured in your filter and then build a custom expression to summarize your data.
Refer to this article about using tags and formulas in dashboards for more information.
If you continue to notice discrepancies in your dashboard values after looking through these common causes, please reach out to our support team.