Grid “flat form” is empty and broken when data contains year/quarter/month/day type

Answered
  • Version: Pivot Table for JSON data sources 2.6.12 (Jan 14, 2019)
  • Browser: Chrome 71.0.3578.98 on MacOS 10.14.1
  • Link to reproducehttp://jsfiddle.net/34aeuhwm/
  • Steps to reproduce:
    • Display pivot table
    • See result of “Total Count of Group” is displayed properly
    • Click on Toolbar > Options > Flat form
    • Click on Apply
    • See grid
  • Observed behavior:
    • Result is incorrectly displayed (no data, or empty grid)
    • Grid is now misaligned and cannot be manipulated (selection, resizing of columns, etc)
    • Error in Chrome JS console:
      • flexmonster.js:9 Uncaught TypeError: Cannot read property 'members' of undefined
        at j9C.ZD (flexmonster.js:9)
        at j9C.getData (flexmonster.js:9)
        at y4y.e9C.getDataFunction (flexmonster.js:9)
        at y4y.getData (flexmonster.js:9)
        at F5m.i98.xd (flexmonster.js:9)
        at M68.Bh (flexmonster.js:9)
        at M68.H1y.Tk (flexmonster.js:9)
        at M68.Aa (flexmonster.js:9)
        at F5m.i98.qy (flexmonster.js:9)
        at F5m.qy (flexmonster.js:9)
  • Expected behavior:
    • Pivot produces a result in flat form when one or more fields have a type “year/quarter/month/day”, independently of their order in the data/configuration.
  • Workarounds:
    • Changing “type” in the JSON data headers from “year/quarter/month/day” to “date” solves the issue (value and no error in console) – Not acceptable since the point is to use the type “year/quarter/month/day”
    • Moving the field of type “year/quarter/month/day” to the last position in the JSON data headers (and changing the order for the data) also solves the issue (value and no error in console) – Not acceptable when data and headers are created dynamically (no control on the order of the fields)
  • Notes:

Attachments:
screen_01.png

1 answer

Public
Dmytro Zvazhii Flexmonster January 22, 2019

Hello,
Thank you for writing to us.
We have managed to reproduce the issue on our side.
The necessary fix will be released in the version with ETA Feb 25.
We will keep you updated.
Regards,
Dmytro

Please login or Register to Submit Answer