[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

--- Comment #10 from kaese...@gmail.com ---
I'd just like to second this, this is a wish I had for YEARS, summing for
variables with numerics in them and counting unique values for anything else
makes just so much more sense and will save users countless clicks. It would be
great if this could be done ...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

   Keywords|needsUXEval |
  Component|LibreOffice |Calc
 CC|libreoffice-ux-advise@lists |tietze.he...@gmail.com
   |.freedesktop.org|
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=90
   ||665

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

--- Comment #9 from Jaka  ---
Just agreeing and noting that the wish to have unique counting as an option is
tracked here: https://bugs.documentfoundation.org/show_bug.cgi?id=90665

I wouldn't say it's a dependency though, since even defaulting to the normal
count for non-numeric fields would be welcome.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

Pénzes Dávid  changed:

   What|Removed |Added

 Blocks||103381


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103381
[Bug 103381] [META] Pivot table (aka Data Pilot) bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

--- Comment #5 from Heiko Tietze  ---
I was looking for a reason to change it in general. The more variants we have
in the program, like ifthen sum or count, the harder is it for users to figure
out why things happens - and the complexity of the code increases.

So the question is why not always (row/col, with/without NAN) calculate the
number of values?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

--- Comment #6 from raal  ---
(In reply to Heiko Tietze from comment #5)

> So the question is why not always (row/col, with/without NAN) calculate the
> number of values?

Because when you change the default (from SUM to COUNT), users will be angry.
When you do what Milan suggested, it's clear enhancement. btw. that's the
behaviour how Excel works.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

--- Comment #7 from Milan Bouchet-Valat  ---
That's right. Another point is that users already have to take into account
different behaviors depending on whether the values are numeric or not: sum
produces an empty result when applied to non-numeric values.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

--- Comment #4 from Milan Bouchet-Valat  ---
(In reply to Heiko Tietze from comment #3)
> Sounds reasonable. First step in an analysis should always be the checking
> of raw data, here the count of valid numbers, followed by the computation of
> descriptive or summative information afterwards.

I'm not sure I understand what you mean here. My proposal concerns only columns
which contain non-numeric values, for which no summation can be done.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

Milan Bouchet-Valat  changed:

   What|Removed |Added

 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org
  Component|Calc|ux-advise

--- Comment #2 from Milan Bouchet-Valat  ---
Let's see what the UX team thinks.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

--- Comment #3 from Heiko Tietze  ---
Sounds reasonable. First step in an analysis should always be the checking of
raw data, here the count of valid numbers, followed by the computation of
descriptive or summative information afterwards.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||r...@post.cz
 Ever confirmed|0   |1

--- Comment #1 from raal  ---
Valid enhancement.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 97513] In Pivot tables, compute sum for numbers and counts for other formats by default

[bugzilla-daemon]

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

Milan Bouchet-Valat  changed:

   What|Removed |Added

Version|unspecified |Inherited From OOo

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs