☝️Small business or a startup? See if you qualify for our special offer.
+
Get Free Trial
Get Free Trial
All documentation
API reference
Objects
Methods
  1. All methods
  2. addCalculatedMeasure
  3. addCondition
  4. alert
  5. clear
  6. clearFilter
  7. clearXMLACache
  8. closeFieldsList
  9. collapseAllData
  10. collapseCell
  11. collapseData
  12. connectTo
  13. customizeAPIRequest
  14. customizeCell
  15. customizeChartElement
  16. customizeContextMenu
  17. dispose
  18. drillDownCell
  19. drillUpCell
  20. expandAllData
  21. expandCell
  22. expandData
  23. exportTo
  24. getAllConditions
  25. getAllHierarchies
  26. getAllHierarchiesAsync
  27. getAllMeasures
  28. getAllMeasuresAsync
  29. getCell
  30. getColumns
  31. getColumnsAsync
  32. getCondition
  33. getFilter
  34. getFlatSort
  35. getFormat
  36. getMeasures
  37. getMeasuresAsync
  38. getMembers
  39. getMembersAsync
  40. getOptions
  41. getReport
  42. getReportFilters
  43. getReportFiltersAsync
  44. getRows
  45. getRowsAsync
  46. getSelectedCell
  47. getSort
  48. getTableSizes
  49. getXMLACatalogs
  50. getXMLACatalogsAsync
  51. getXMLACubes
  52. getXMLACubesAsync
  53. getXMLADataSources
  54. getXMLADataSourcesAsync
  55. getXMLAProviderName
  56. getXMLAProviderNameAsync
  57. load
  58. off
  59. on
  60. open
  61. openCalculatedValueEditor
  62. openFieldsList
  63. openFilter
  64. print
  65. refresh
  66. removeAllCalculatedMeasures
  67. removeAllConditions
  68. removeCalculatedMeasure
  69. removeCondition
  70. removeSelection
  71. runQuery
  72. save
  73. scrollToColumn
  74. scrollToRow
  75. setFilter
  76. setFlatSort
  77. setFormat
  78. setOptions
  79. setReport
  80. setSort
  81. setTableSizes
  82. shareReport
  83. showCharts
  84. showGrid
  85. showGridAndCharts
  86. sortFieldsList
  87. sortingMethod
  88. sortValues
  89. updateData
Events
Custom data source API
MongoDB Connector API
Chart connectors

showGridAndCharts

showGridAndCharts(type: String, position: String, multiple: Boolean)

[starting from version: 1.9]

Switches to the grid and charts view and shows the chart of the specified type. The following chart types are supported: "column", "bar_h", "line", "scatter", "pie", "stacked_column" and "column_line".
After showGridAndCharts() API call, the viewType option in the report will be "grid_charts".

Parameters

Parameter/TypeDescription
type
String		optional The type of charts to show.
Default value: "column".
position
String		optional Position of charts related to the grid. It can be "bottom", "top", "left", or "right".
Default value: "bottom".
multiple
Boolean		optional To show one measure on the chart (false) or multiple (true) - as many measures as selected in the slice.
Default value: false.

Examples

1) Show grid and charts:

pivot.showGridAndCharts();

Open on JSFiddle.

2) Show line chart at the left:

pivot.showGridAndCharts("line","left");

Check out on JSFiddle.

See also

showCharts
showGrid