In a chart I have to count cases by a special information called “priority”, I have 11 differents priorities but the chart only have to show 5 of the them in 5 different columns dinamically, and the rest of the count cases with differents priorities must be displayed in a sigle column called “other”.
I’m using a Report Definition to filter only the 5 priorities that I need. What should I do to put all other priorities into “other” column in the chart?.
One way to do this would be to implement a SQL function alias (e.g., “Other”) that would return false/zero for the 5 specific priorities you are pulling out, and true/one for all others. You could then add a column to your report with a count of “Other” cases.
Please post a screen shot of the Query tab of your report definition. If you are using “Count” as the Summarize function, you may want to return null from the “Other” FA for the specific priorities.
