Retrieval of record data for charts with grouping

Certified Senior Developer

Hello,

I want understand how the data is retrieved when we use chart with grouping.

For charts In data we give recorddata (retrieve the data with filters) and then it is grouped using primary or secondary grouping(column charts)

I want to know if internally. the whole data is retrieved and then grouped or the data is grouped and retrieved?

If the data is retrieved and then grouped , then i can use local variable and save the recorddata() and then give the data to chart for grouping. if i do this whole data is stored in local variable. 

if im using a drillable grid then i can reuse it. But to reuse this data i need to again filter this with the selected (data clicked on) grouping. 

1. I want to know if internally. the whole data is retrieved and then grouped r the data is grouped and retrieved? Can i load data in local variable as shown below pic.

2. If its the earlier, then given a recorddata how can i then filter it to get only few rows out of the whole? below pic-> i want only 10 rows from columnChartdata depending on which column chart peak the user clicks on

  Discussion posts and replies are publicly visible