Pivot table is blank but drill down still works

posted on April 29th, 2022

Answered

dan asked on April 29, 2022

Hi Support
For some unknown reason Flexmonster is showing blank data at the pivot table level, however if we click on the blank area the drill down still comes up. Screenshots attached.
It appears that the pivot table is somehow invisible.
We are using Flexmonster version 2.9.15-1, on React 17.0.1
regards
Dan

Attachments:
flexmonster issue 1.png
flexmonster issue 2.png

5 answers

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ April 29, 2022

Hello, Dan!

Thank you for reporting this issue.

Kindly note that there can be several reasons to cause such behavior.
Our team wants to ask you for more details to continue the investigation:

The screenshot of your console if it has any exceptions. For that, you should open dev tools in the browser(press F12) and go to the console tab.
The JSFiddle with sample data on which the issue is reproducible would also be a great help.

Looking forward to your response.

Regards,
Solomiia

Public

dan ⋅ May 3, 2022

Thanks Solomiia
Got this error in console, hopefully that's the cause of the issue?

flexmonster.full.js:852 Uncaught TypeError: Cannot read properties of undefined (reading 'da')
at i.cr (flexmonster.full.js:852:114)
at i.Ha (flexmonster.full.js:1081:327)
at a.Ha (flexmonster.full.js:928:114)
at i.YG (flexmonster.full.js:1730:107)
at i.getData (flexmonster.full.js:1729:122)
at xpa.Fva.t.MC (flexmonster.full.js:1721:211)
at xpa.getData (flexmonster.full.js:1837:451)
at r.ig (flexmonster.full.js:1904:83)
at e.kn (flexmonster.full.js:1896:310)
at e.Fy (flexmonster.full.js:1819:166)

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ May 3, 2022

Hello, Dan!

Thank you for your swift response.

Kindly note that this error message can be caused by different reasons, so we still need more details to understand the matter.
Could you please modify the following JSFiddle to make your case reproducible: https://jsfiddle.net/flexmonster/ogc18q60/.

Looking forward to hearing from you.

Regards,
Solomiia

Public

dan ⋅ May 4, 2022

Thanks Solomiia.
Turns out it's caused by a column was renamed, but the name was not change in a calculated field which does running total, and that drags the whole pivot down.

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ May 4, 2022

Hello, Dan!

Thank you for your response.

We are happy to hear that you found a solution.

Please feel free to ask if any further questions arise.

Regards,
Solomiia

Pivot table is blank but drill down still works

5 answers

Please login or Register to Submit Answer