Data > Group on Pivot table creates a mirror date column instead of grouping into hours

[Tobruk]

According to the LibreOffice Manual, after clicking Data > Group, a popup window should appear that allows me to choose how to group a given pivot table.

So, since I wanted to group my pivot table into hour groups based on date column (dd::mm::yyyy hh:mm::ss), I thought I’d use this feature.

However, after clicking Data > Group, Calc merely creates another column with the same data as the original column with dates. (and names it days since starting date2) There is no option to choose how to group the data.

This is my pivot table:

[mikekaganski]

Try with dates as column fields, not as row fields

[SM_Riga]

Hello @Tobruk

Make sure your date column holds actually date/time values, not text string representing date. That is the reason why it is not possible to group Pivot Table results by time periods. When you try to group cells containing text string, Pivot Table just creates same column aside to original one (bug possibly?). Please see this answer with step by step manual on creating Pivot table and grouping result.

—Edit 2019-03-20 22:19—

Added sample file. One sheet contains Pivot Table created from Date/Time values formatted as YYYY-MM-DD HH:MM:SS, other sheet holds identical Pivot Table created from text strings looking exactly the same as YYYY-MM-DD HH:MM:SS Try to group both of them.