We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.
Download

How to use Google Chart when pivot table is in Flat mode?

posted on June 10th, 2019

Answered
Elisa asked June 10, 2019

Hi, I am able to show a pie chart with classic type of pivot table, but when I set the type to flat by default the chart was unable to show.
Here is the error

core.js:15724 ERROR TypeError: Cannot read property 'members' of undefined
    at A4n.composeData (webdatarocks.js:6)
    at A4n.getData (webdatarocks.js:6)
    at R1n.getData (webdatarocks.js:6)
    at I5v.getData (webdatarocks.js:6)
    at Object.PivotApi.W1C.getData (webdatarocks.js:6)
    at Object.WebDataRocksGooglecharts.getData (webdatarocks.googlecharts.js:31)
    at ByProductComponent.push../src/app/pages/product-report/by-product/by-product.component.ts.ByProductComponent.createGoogleChart (by-product.component.ts:111)
    at ByProductComponent.push../src/app/pages/product-report/by-product/by-product.component.ts.ByProductComponent.onReportComplete (by-product.component.ts:99)
    at SafeSubscriber._next (outlet.service.ts:387)
    at SafeSubscriber.push../node_modules/rxjs/_esm5/internal/Subscriber.js.SafeSubscriber.__tryOrUnsub (Subscriber.js:196)

Thank you.

1 answer

WebDataRocks Team ⋅ WebDataRocks ⋅ June 13, 2019

Hi, Elisa,

Thank you for writing to us.

We would like to specify that getData method was designed to help get already aggregated data for charts. As a result, it is capable of returning aggregated data only (from compact mode and classic mode). You can get the raw data directly from the data source.
Hope it helps.
Regards,
WebDataRocks Team