I have a number of records with "Total number of Actions" and "Actions Overdue" measures. I've created a calculated measure to show the percentage of overdue actions.
I wish to display the count of records grouped by the percentage of overdue actions. For example, I want to show in a column chart the number of projects with less than %10 overdue, between 10-20% overdue, etc, etc. I created a calculated field using an "if then elseif" statement to identify the percentage for each record, but it's created as a measure and not a dimension.
Anyone able to explain how I can do this? Unfortunately I can't post an example.
Fixed based on the dimension using in granularity related to that it will get stored in measure or Dimension that's known functionality
