[Bug 159180] Add support for refined-doughnut charts

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=159180

--- Comment #6 from Eyal Rozenberg <eyalroz1 at gmx.com> ---
(In reply to Heiko Tietze from comment #5)
> (In reply to Eyal Rozenberg from comment #4)
> > There is just one column of data. The doughnut rings display different
> > levels of aggregation.
> You mean the chart should do all the pivot table work?

Actually, I'm not sure our PivotTables mechanism can do all of this at once,
i.e. with gradually refined subtotals as we expose more key fields. Can it? I
wonder if one can get Excel PivotTables to do it.

But - sort of.

> > (In reply to Heiko Tietze from comment #3)
> Please explain so it's easy to understand.

Suppose your table is:

L1      L2      L3      Num Items
Clothing        Shirts  sh1     10
Clothing        Shirts  sh2     10
Clothing        Shirts  sh3     8
Clothing        Pants   p1      14
Clothing        Pants   p2      5
Footware        Boots   b1      6
Footware        Boots   b3      7
Footware        Boots   b4      9

You can't have a 3-ring doughnut chart with this. But you can have a 3-ring
refined doughnut chart with it. The first ring has two sections:

Clothing 47
Footware 22

the second ring has 3 sections:

Shirts 28
Pants  19
Boots  22

and the third ring has 8 sections with the full data column for their values.
And the sections line up so that the ring 2 sections for clothes cover the same
angular ranges as the Clothes section in ring 1 etc.

-- 
You are receiving this mail because:
You are on the CC list for the bug.