In a pie-chart report, how to group sections into 1?

[Bruno Martin]

Hi,

I'm building a pie-chart report where I have 1 main section (empty value) and few more sections (different values) like the following picture is showing:

I would like to group those few more sections with different values into 1 section which I will call "not empty" in order to get such pie-chart report:

Is that possible and how can I do that?

Thanks,

BR

Bruno

[Mohith Devatte]

Hello @Bruno Martin ,

so you are building this report though normal reporting module ?

if yes you would have grouped by some field which are nothing but your PIE's with data labels are those values in that group by field.

So it depends on values in the field completely .

like group by priority on incident table 

1 , ,2 ,3,4,5 - which are priorities and if you do group by it shows 5 pies each representing respective priorities .

So if you want to combine you need to have a combined field value in order to do this other wise we dont have any option 

please mark my answer correct if it helps you

[Bruno Martin]

Correct, I'm building the report through normal reporting module.

When you say "to have a combined field value", can you be more explicit?

Isn't it possible to have something scripted like:

var val = "";
if (field != null) { 
    val = "not empty";
} else { 
    val = "empty";
}

and then grouping on 'val' value...therefore showing 2 section in the PIE.

Thanks

[DJL2]

Hi Bruno,

What Mohith is saying is that you need a value which generates a binary outcome: 'Yes' / 'No', 1 or 0 etc.  You then apply a grouping against that field, which would generate your consolidated slice.

Personally, I think it's a strange requirement for the following reasons:

1. In your first pie chart, it is obvious that the sum of the smaller slices is 8% Why?  Because the maths here is simply 100% - 92%
2. Consolidating your 4%, 3% and 1% into "8%" dilutes detail.  If the 92% = nothing, then surely the insight is the breakdown of that 8% ?

I get that 92% v 8% is visually neater - but is that really the important thing?

The above might not help; more of a different perspective.

Thanks,

DJL

[Bruno Martin]

Hi DJL,

Indeed your perspective is relevant.

Mohith's solution would have helped if able to find a combined field value...Unfortunately there was none.

And I found the KB article which helped me solving my display issue.

Thanks @DJL and @Mohith Devatte 

Best regards,

Bruno