We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

Pivot table is blank but drill down still works

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

5 answers

Public
Solomiia Andrusiv 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:

  1. 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.
  2. 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 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 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

Please login or Register to Submit Answer