To keep the Viz simple, I like to to say we will SUM up the values if there are multiple y values for same x values. If you need any other functions, you do it in BAM or CEP.
--Srinath On Mon, Dec 15, 2014 at 7:55 AM, Joseph Fonseka <[email protected]> wrote: > > +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>* > > -- ============================ Blog: http://srinathsview.blogspot.com twitter:@srinath_perera Site: http://people.apache.org/~hemapani/ Photos: http://www.flickr.com/photos/hemapani/ Phone: 0772360902
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
