Permission settings or the dimension members 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 helps you correct them.
Users 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 user 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 that may be seen when building or interacting with dashboards.
For example, if a user is restricted to only their own departmental data, they won't see all department totals when working with dashboards.
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 dimension members that make up the formula are captured in your filter and then building 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.