Hi Isuru, 1. DAS 3.0.0 does not support sorting aggregated data. But it can be considered as an improvement in 3.0.01
2. DAS 3.0.0 REST API support ranged faceting. You will have to give the boundaries for each range with a label name. Please refer to [1] for more info. [1] https://docs.wso2.com/display/DAS300/Retrieving+the+Event+Count+of+Range+Facets On Fri, Nov 20, 2015 at 12:01 PM, Rukshan Premathunga <[email protected]> wrote: > Hi Isuru, > > For 2nd issue, you can try with lucene range search[1]. > > [1] https://lucene.apache.org/core/2_9_4/queryparsersyntax.html#Range > Searches > > Thanks and Regards. > > On Fri, Nov 20, 2015 at 5:37 PM, Isuru Wijesinghe <[email protected]> > wrote: > >> Hi All, >> >> We're currently developing the dashboard for BPS statistics data and we >> encounter some problems mentioned below. >> >> 1.) Does DAS already support a sorting feature to retrieve the aggregated >> data in the ascending order ? >> >> Why we need sorting feature here because let's say as an example, if we >> are analyzing the involvement of different users in a particular process, >> we have to provide the process ID as the primary filter. There can be a >> large number of users in the system which could result in too many entries >> in the X axis. To overcome this, most graphs have to provide a secondary >> filter to obtain only top X or bottom X entries (asc or dsc ordering). >> >> When retrieving the records through the faceted search for the columns >> which have the aggregated values(eg: avg, sum, etc) from the DAS REST API, >> the data is usually listed in random order. As a solution for that, need to >> provide a mechanism in the DAS side to sort the records in the column such >> a way that they will be retrieved in a specific order so that it can be >> used to sort in ascending order, descending order according to the given >> column or multiple columns. >> >> eg: { >> "tableName": "USER_INVOLVE_SUMMARY_DATA", >> "groupByField": "processDefKey", >> "query": "assignee:admin", >> *"sort":"totalInvolvedTime asc"*, >> "aggregateFields": [ >> { >> "fieldName": "duration", >> "aggregate": "SUM", >> "alias": "totalInvolvedTime" >> } >> ] >> } >> >> 2.) Is it possible to do range faceting in DAS? >> >> (Here the range facet produces multiple range buckets over numeric fields >> or date fields.) >> Let's say as an example we have a field called *price* in one of the >> summarized tables and we have that field faceted. We want to get the facets >> as ranges of values (*eg:* *0-100, 100-500, 500-1000, etc* - these are >> the ranges that prices fall into). Is it possible to calculate the ranges >> (facet counts for the ranges of prices - eg: say for 5 values) based on the >> values in the table ? >> >> -- >> Isuru Wijesinghe >> *Software Engineer* >> WSO2 inc : http://wso2.com >> lean.enterprise.middleware >> Mobile: 0710933706 >> [email protected] >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Rukshan Chathuranga. > Software Engineer. > WSO2, Inc. > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Gimantha Bandara Software Engineer WSO2. Inc : http://wso2.com Mobile : +94714961919
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
