Get Free Trial

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

Projet TCD asked on January 22, 2019
  • 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 reproduce
  • 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:


3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster January 22, 2019

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.

Iryna Kulchytska Iryna Kulchytska Flexmonster February 27, 2019


I’m glad to inform you that the version with the fix has already been released.
Please feel free to update the component.

Let us know if everything works fine for you.

Kind regards,

Projet TCD April 2, 2019

Hello, thank you for the fix. The most urgent part of the issue seems fine (breaking the grid), but the disctinct count still isn’t correct.
I’ve reported the issue with new reproduction steps here:

This question is now closed