Get Free Trial

How can I get a distinct list from drill through

Answered
Mark Waller asked on November 11, 2021

We have several reports where we are plotting the distinct count of users. It would be really useful to be able to drill through and retrieve the distinct list, rather than the full list. Often the full list has thousands of rows. 
How can we see the distinct list rather than the full one? 

Attachments:
drill_through.png

4 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 11, 2021

Hello, Mark,

Thank you for raising this ticket.
 
Please note that the drill-through view is designed to represent raw records that were used to calculate the drilled intersection. In its turn, the distinct count aggregation considers all the records to count the number of unique values. It means all the records will be eventually displayed in the drill-through.
Another behavior would impose major ambiguity in terms of choosing the records to display in the drill-through.
 
We hope it helps.
Feel free to contact us if other questions arise.
 
Kind regards,
Illia

Public
Mark Waller November 11, 2021

Okay, is there a way to add a new function to that menu? It would need to be passed the raw data so it could process it for itself. 

Public
Mark Waller November 11, 2021

I.e. add an extra menu item, that calls out to a function that I can write, and is passed the data so my function can process it.

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 11, 2021

Hi, Mark,
 
Flexmonster does not provide the possibility to reprocess the data passed to the drill-through view.
 
As a workaround, you can disable the default drill-through view and define a unique record identifier for each entry in your data set. Set type of this identifier to id using the MappingObject.
Finally, use the celldoubleclick handler to retrieve all the record identifiers used to compose the clicked cell. This set of identifiers can be used to select the data from the initial data set and preprocess it in the desired way. After reprocess, you can either show the data in the custom pop-up or use a temporary Flexmonster instance with the flat form to represent the resulting data.
 
Here is the JSFiddle we prepared for a brief demonstration: https://jsfiddle.net/flexmonster/dmn2u6ax/. Try double-clicking any cell to receive the set of the used identifiers.
 
Please let us know if it helps.
 
Kind regards,
Illia

Please login or Register to Submit Answer