+1 , Are we going to add aggregate functions as well ( Ex. AVG ) to support following types of queries.
Plot line chart of AVG GDP per decade. Thanks Jo On Mon, Dec 15, 2014 at 12:00 AM, Anjana Fernando <[email protected]> wrote: > > More correctly, most probably BAM 3.1 plans :) .. > > Cheers, > Anjana. > > On Mon, Dec 15, 2014 at 7:16 AM, Anjana Fernando <[email protected]> wrote: >> >> Hi, >> >> I guess, for BAM 3.0, this can be the base for our eventual KPI >> implementation as well. We will just need some additional functionality to >> provide some limits to the data/visualizations we are having, and to show >> it in an appropriate way, and to trigger alerts etc.. Looking forward to >> checking out the initial implementation of this, so probably the BAM team >> can enhance it with the other required features. >> >> Cheers, >> Anjana. >> >> On Mon, Dec 8, 2014 at 7:42 PM, Srinath Perera <[email protected]> wrote: >>> >>> Currently to visualize the data, users have to write their own gadgets. >>> If a advanced user this is OK, but not for all. Specially, things like >>> drill downs need complicated planning. >>> >>> I believe it is possible to start with data in tabular form, and write a >>> generic Gadget that let user configure and create his own data chart with >>> filters and drill downs. >>> >>> Chart could look like following ( some of the controls can be hidden >>> under configure button) >>> >>> >>> Lets work though an example. >>> >>> 1) Key idea is that we load data to the Gadget as a table (always). >>> Following can be a example data. >>> *Country* *Year* *GDP* *Population* *LifeExpect* Sri Lanka 2004 20 >>> 19435000 73 Sri Lanka 2005 24 19644000 73 Sri Lanka 2006 28 19858000 >>> 73 Sri Lanka 2007 32 20039000 73 >>> 2) When Gadget is loaded, it shows the data as a table. User can select >>> and add a data type and fields. Following are some example. >>> >>> 1. Line - two Numerical fields >>> 2. Bar - one numerical, one categorical field >>> 3. Scatter - two numerical fields >>> 4. Map - Location field + categorical or numerical field >>> 5. Graph - two categorical or string fields that provide links >>> >>> >>> 3) Let user add more information to the chart using other fields in the >>> table >>> >>> 1. Add color (Categorical field) or shade (numerical field) to the >>> plot (e.g. Use different color for each country) >>> 2. Point Size - Numerical field (e.g. Adjust the point size in the >>> scatter plot according to the population) >>> 3. Label - any field >>> >>> 4) Then he can add filters based on a variable. Then the chart will have >>> sliders (for numerical data) and tick buttons (for categorical data). When >>> those sliders are changed they will change the chart. >>> >>> 5) Final step is define drill downs. Drill downs are done using two >>> columns in the table that has hierarchical relationships. (e.g. Country and >>> State fields, Year and month fields) . We need users to select two of those >>> fields and tell us about relationships and then we can code the support of >>> drill downs. >>> >>> When above steps are done, user save configs and save it in the DataViz >>> store as a visualisation, so others can pull it and use it. >>> >>> This will not cover all cases, but IMO it will cover 80% and also a very >>> good tool for demos etc. >>> >>> Please comment >>> >>> --Srinath >>> >>> >>> >>> -- >>> ============================ >>> Blog: http://srinathsview.blogspot.com twitter:@srinath_perera >>> Site: http://people.apache.org/~hemapani/ >>> Photos: http://www.flickr.com/photos/hemapani/ >>> Phone: 0772360902 >>> >> >> >> -- >> *Anjana Fernando* >> Senior Technical Lead >> WSO2 Inc. | http://wso2.com >> lean . enterprise . middleware >> > > > -- > *Anjana Fernando* > Senior Technical Lead > WSO2 Inc. | http://wso2.com > lean . enterprise . middleware > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- -- *Joseph Fonseka* WSO2 Inc.; http://wso2.com lean.enterprise.middleware mobile: +94 772 512 430 skype: jpfonseka * <http://lk.linkedin.com/in/rumeshbandara>*
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
