Hi all, With the current implementation of UES gadget gen tool we can support all the features except the drill down feature. Please note that this is using the flot charting library and if we are to go ahead with D3 we need to model accordingly. Please find my inline comments.
On Mon, Dec 8, 2014 at 12:12 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 > > At the moment we can give an SQL query and choose columns from the provided dataset depending on the chart type. > > 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 > > If I take the same example that you have taken, all these filters will work if you generate a multiple series bubble chart. Multiple series - each country will be a different series on the same chart. Size of the bubble - will be the population. User has to identify the suitable chart type for his visualization and can generate accordingly. > 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. > Categorical support over tick button is already there for different series. Although slider feature doesn't come with the gadget gen tool, this can be implemeted using pub-sub model where we can extend the gadget gen tool to integrate with the model. We have done a similar one (not auto generated) for App factory. > > 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. > At the moment we don't have this feature. +1 to add to the roadmap. > > 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 > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- Tanya Madurapperuma Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
