This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Please review this video:https://youtu.be/_Ohs06frNAAThis video shows:
- how to highlight the maximum value in a column chart to instantly draw attention to key insights.
Formula looks good.
I will recommend to add this as a formula column (flag with 0 or 1 value)) in physical table and then use aggregation on this flag to show in insight in dashboard.
P6ETLDB data source (shown in the attached screenshot) is pointing to which database?For example, If it is pointing to Oracle DB you need to look at Oracle DB docs for TRIM function that you can use w SQL.
You can use level based measure function to calculate sales total for quarter (Sum of Jan +Feb+Mar).In your case formula can be:SUM( <Revenue>, groupBy(<customer>, <quarter>) ) To calculate ratio use this formula:SUM( <Revenue> ) /SUM( <Revenue>, ...
.png "Employee"){kind=icon}
