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
Hi,
Rather than using recordData, you can create and set your dataSubset to a local variable and use that as data in the report.
Please see the year-over-year-report pattern that come with designer.
docs.appian.com/.../year-over-year-report-pattern.html
But i want to fetch data from record type and not entity. My main question is how does it work internally? Does it fetch all the data or only the count per grouping?