Hi Tharindu, The 2D table works with aggregation. Thanks. The cell colouring should look like the below example, where the color gradient applies to the entire data-set as opposed to individual columns.
*Candidate\City_ID* *1* *2* *3* *5* *A* 11 0 5 3 *B* 3 5 8 9 *C* 1 9 5 6 *D* 0 0 0 6 seshika On Sat, Mar 28, 2015 at 5:02 PM, Tharindu Munasinghe <[email protected]> wrote: > Hi Seshika, > > The sample attached here will transform the dataset and draw the > table as you said. let me know the changes to be made . > > http://dunithd.github.io/igviz/samples/transformedTable/index.html > > Thanks, > > On Thu, Mar 26, 2015 at 7:34 PM, Seshika Fernando <[email protected]> > wrote: > >> Hi Tharindu, >> >> Can I use aggregate functions with Tables as well? >> >> seshi >> >> >> On Thu, Mar 26, 2015 at 5:44 PM, Seshika Fernando <[email protected]> >> wrote: >> >>> Oh this is good news indeed. Will use it. >>> >>> On Thu, Mar 26, 2015 at 5:31 PM, Tharindu Munasinghe <[email protected] >>> > wrote: >>> >>>> Time domain is already there in igviz.js [1], You have to specify 'T' >>>> as the type of the relevant field and pass the date/time as String value. >>>> >>>> Since time is continuous variable you can't s use it on Bar charts( >>>> which need a discrete domain for X-axis ). For other types of charts like >>>> area ,line and scatter you can use it. >>>> >>>> >>>> [1] http://dunithd.github.io/igviz/samples/discreteTime/index.html >>>> >>>> On Thu, Mar 26, 2015 at 3:57 PM, Seshika Fernando <[email protected]> >>>> wrote: >>>> >>>>> Yes +1 to the time domain. Right now I'm converting the time into a >>>>> date and then manually doing manipulations. This will be very useful. >>>>> >>>>> On Thu, Mar 26, 2015 at 3:38 PM, Dunith Dhanushka <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi Tharindu, >>>>>> >>>>>> We might need to consider using time domain as well. Since most of >>>>>> the usecases involve visualizing timeseries data. So it'd be nice to >>>>>> have a >>>>>> time domain in addtion to linear and ordinal domains. >>>>>> >>>>>> Regards, >>>>>> Dunith >>>>>> >>>>>> On Thu, Mar 26, 2015 at 3:08 PM, Tharindu Munasinghe < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> Hi Seshika, >>>>>>> >>>>>>> count() is fixed and now min,max,sum,avg and 'count'. are the >>>>>>> possibilities for aggregation . Please use the direct link [1] instead >>>>>>> of >>>>>>> downloaded igviz.js as it will reflect the latest updates . >>>>>>> >>>>>>> [1] : http://dunithd.github.io/igviz/igviz.js >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> On Thu, Mar 26, 2015 at 2:18 PM, Tharindu Munasinghe < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> igviz.js uses the aggregated functions that are supported by >>>>>>>> vega.js . min,max,sum,avg are the functions that I have tested and >>>>>>>> they >>>>>>>> are working . I tested count() but didn't get the result I expected . >>>>>>>> I >>>>>>>> 'll fix it . >>>>>>>> >>>>>>>> On Thu, Mar 26, 2015 at 1:38 PM, Seshika Fernando <[email protected] >>>>>>>> > wrote: >>>>>>>> >>>>>>>>> What are the aggregate functions that I can use? I see 'sum' is >>>>>>>>> available. Does this support Count too? >>>>>>>>> Please let me know what are the functions that are currently >>>>>>>>> supported. >>>>>>>>> >>>>>>>>> Thanks >>>>>>>>> >>>>>>>>> On Thu, Mar 26, 2015 at 1:36 PM, Seshika Fernando < >>>>>>>>> [email protected]> wrote: >>>>>>>>> >>>>>>>>>> Noted and Thanks. Will try this out. >>>>>>>>>> >>>>>>>>>> On Thu, Mar 26, 2015 at 1:34 PM, Tharindu Munasinghe < >>>>>>>>>> [email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> Hi Seshika, >>>>>>>>>>> I have updated the igviz.js so that now aggregated >>>>>>>>>>> functions can be used with bar charts. if you don't use aggregate >>>>>>>>>>> functions >>>>>>>>>>> , bar chart will only show the last Y value for repeated X. A >>>>>>>>>>> sample for >>>>>>>>>>> aggregated bar can be found at [1] >>>>>>>>>>> >>>>>>>>>>> Please note that , as for the moment adding a title to the plot >>>>>>>>>>> only works with aggregated bar charts. >>>>>>>>>>> >>>>>>>>>>> [1] http://dunithd.github.io/igviz/samples/aggregate/index.html >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Tue, Mar 24, 2015 at 11:01 AM, Tharindu Munasinghe < >>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi All, >>>>>>>>>>>> >>>>>>>>>>>> Today I had a progress update of igviz.js with Srinath .He >>>>>>>>>>>> pointed out several improvements for the project. >>>>>>>>>>>> >>>>>>>>>>>> - Add graph sketching support to igviz.js >>>>>>>>>>>> - Come up with a tabular representation for a graph >>>>>>>>>>>> - Improve the styles in samples site >>>>>>>>>>>> - Add single number diagram ( min/max/average.. with a >>>>>>>>>>>> distribution curve or histogram) >>>>>>>>>>>> - Add more aggregate function (min,max,avg..) support to >>>>>>>>>>>> dirll-down feature >>>>>>>>>>>> >>>>>>>>>>>> Currently this library supports following visualizations and >>>>>>>>>>>> features.Please find the source code of igviz.js [2] >>>>>>>>>>>> <https://github.com/dunithd/igviz> and the samples site [1] >>>>>>>>>>>> <http://dunithd.github.io/igviz/samples/> , Any >>>>>>>>>>>> thoughts/suggestions are highly appreciated >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> *Charts ( All of these charts are implemented in Vega.js)* >>>>>>>>>>>> >>>>>>>>>>>> 1. Bar Charts >>>>>>>>>>>> 1. Two dimensional Bar chart >>>>>>>>>>>> 2. Grouped Bar chart >>>>>>>>>>>> 3. Stacked Bar chart >>>>>>>>>>>> 2. Line Charts >>>>>>>>>>>> 1. Single Series Line chart >>>>>>>>>>>> 2. Multi series line chart >>>>>>>>>>>> 3. Area Charts >>>>>>>>>>>> 1. Single series area chart >>>>>>>>>>>> 2. Multi series area chart >>>>>>>>>>>> 3. Stacked area chart >>>>>>>>>>>> 4. Scatter Plot >>>>>>>>>>>> 1. Four Dimensional charts (x,y,point color,point size) >>>>>>>>>>>> >>>>>>>>>>>> *Other Types of Visualizations ( Implemented in D3.js)* >>>>>>>>>>>> >>>>>>>>>>>> - Map >>>>>>>>>>>> - Arc (Progress representation) >>>>>>>>>>>> - Table Representation of a data table (Conditional >>>>>>>>>>>> formating based on dataset) >>>>>>>>>>>> >>>>>>>>>>>> *Features of Charts* >>>>>>>>>>>> >>>>>>>>>>>> - Legends (B2,B3,L2,A2,A3) >>>>>>>>>>>> - Tool-tips (L1,L2,A1,A2, S1) >>>>>>>>>>>> - Drill Downing (B1) >>>>>>>>>>>> - Grids (users can configure as they want) >>>>>>>>>>>> - Real Time updates (B1,A1,A2,L1) >>>>>>>>>>>> - Responsive Handlers And Dynamic Resizing >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> *Basic API* >>>>>>>>>>>> >>>>>>>>>>>> chart = igviz.setup("#divID",chartConfig,dataTable.metadata) >>>>>>>>>>>> //chartConfig-minimal >>>>>>>>>>>> set of parameters >>>>>>>>>>>> chart.setXaxis(axisConfig) >>>>>>>>>>>> .setYaxis(yaxisConfig) >>>>>>>>>>>> .setDimension(dimensionConfig) >>>>>>>>>>>> //optional visual customization >>>>>>>>>>>> >>>>>>>>>>>> chart.plot( dataTable.data, callBack); //draw the >>>>>>>>>>>> charts based on the parameters >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> chart.update(newData) >>>>>>>>>>>> //real-time >>>>>>>>>>>> updating >>>>>>>>>>>> chart.resize() //Responsive Handler >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> [1] http://dunithd.github.io/igviz/samples/ >>>>>>>>>>>> [2] https://github.com/dunithd/igviz >>>>>>>>>>>> [3] Generic UI Parameter Names >>>>>>>>>>>> <https://docs.google.com/a/wso2.com/spreadsheets/d/1tCf3lTZ7kkEXdK7T75tKEXqm0QhsZZpiF47saKNMboc/edit#gid=0> >>>>>>>>>>>> >>>>>>>>>>>> Thanks, >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Tue, Mar 3, 2015 at 6:02 AM, Tharindu Munasinghe < >>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> +1 , I will do a bar chart sample using 'Vega' with the >>>>>>>>>>>>> features we have discussed and then we will see how we can extend >>>>>>>>>>>>> that >>>>>>>>>>>>> implementation to the other types of charts :) >>>>>>>>>>>>> >>>>>>>>>>>>> On Mon, Mar 2, 2015 at 6:05 PM, Dunith Dhanushka < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> Hi all, >>>>>>>>>>>>>> >>>>>>>>>>>>>> Today we had a discussion on using Vega [1] library >>>>>>>>>>>>>> underneath igviz. Vega comes with a highlevel visualization >>>>>>>>>>>>>> grammer that >>>>>>>>>>>>>> runs on top of D3. In addition to that it's got some polished UI >>>>>>>>>>>>>> so that >>>>>>>>>>>>>> it'll save more efforts for fine tuning the charts. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Please refer mail thread [RFC: Building a Generic >>>>>>>>>>>>>> Configurable UI Gadget for Analytics] for a background on IGviz. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Igviz's main API interface is >>>>>>>>>>>>>> >>>>>>>>>>>>>> var chart = igviz.plot(canvas,chartConfig,dataTable); >>>>>>>>>>>>>> >>>>>>>>>>>>>> Plan is to keep Igviz's plot() method unchanged and transform >>>>>>>>>>>>>> DataTable and chartConfig objects to the format that vega >>>>>>>>>>>>>> expects. >>>>>>>>>>>>>> >>>>>>>>>>>>>> where canvas is the div element that chart is being drawn, >>>>>>>>>>>>>> chartConfig is the JSON object that contain parameters >>>>>>>>>>>>>> required to draw the chart. (E.g xAxis, yAxis, width, height) >>>>>>>>>>>>>> dataTable is the JSON formatted tabular data structure that >>>>>>>>>>>>>> passes data for the chart >>>>>>>>>>>>>> >>>>>>>>>>>>>> Following are the discussed action items: >>>>>>>>>>>>>> >>>>>>>>>>>>>> 1. Keep the current DataTable structure intact and have Igviz >>>>>>>>>>>>>> trasform it to the format that vega expects. >>>>>>>>>>>>>> 2. Depending on the chartConfig.chartType, create Vega's >>>>>>>>>>>>>> marks[] components. >>>>>>>>>>>>>> 3. Explore the possibility of doing drill downs using Vega. >>>>>>>>>>>>>> (Tharindu has already done that on Igviz) >>>>>>>>>>>>>> 4. Figure out a way of upadting the chart dynamically. We >>>>>>>>>>>>>> agreed to make DataTable's schema fixed during the update. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Tharindu, please add anything I missed here. >>>>>>>>>>>>>> >>>>>>>>>>>>>> [1] http://trifacta.github.io/vega/ >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks, >>>>>>>>>>>>>> Dunith >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Mon, Mar 2, 2015 at 10:52 AM, Tharindu Munasinghe < >>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi all, >>>>>>>>>>>>>>> Pubudu,Fawsan and Fasna has started this project as >>>>>>>>>>>>>>> their training project and they did the implementations of >>>>>>>>>>>>>>> table, single >>>>>>>>>>>>>>> value , map , line charts . Me and Dunith have been continuing >>>>>>>>>>>>>>> this >>>>>>>>>>>>>>> project to make it a generic library so that any product can >>>>>>>>>>>>>>> use it. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> So far igviz.js library supports bar charts ,scatter >>>>>>>>>>>>>>> plots, tables , maps , single number graph , line and area >>>>>>>>>>>>>>> charts with >>>>>>>>>>>>>>> drill-downing options for hierarchical data sets . >>>>>>>>>>>>>>> Please find the samples hosted at [1] and the >>>>>>>>>>>>>>> implementation at [2]. Documentation for the configuration >>>>>>>>>>>>>>> parameters can >>>>>>>>>>>>>>> be found at [3] . >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> [1] igviz.js samples >>>>>>>>>>>>>>> <http://dunithd.github.io/igviz/samples/> >>>>>>>>>>>>>>> [2] igviz.js source code <https://github.com/dunithd/igviz> >>>>>>>>>>>>>>> [3] GenericUIParameterNames >>>>>>>>>>>>>>> <https://docs.google.com/a/wso2.com/spreadsheets/d/1tCf3lTZ7kkEXdK7T75tKEXqm0QhsZZpiF47saKNMboc/edit#gid=0> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Thanks, >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> *Tharindu Munasinghe* >>>>>>>>>>>>>>> Software Engineering Intern >>>>>>>>>>>>>>> WSO2 Inc.(http://wso2.com) >>>>>>>>>>>>>>> SRI LANKA >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Mobile: +94 77460887 >>>>>>>>>>>>>>> E-Mail: [email protected] >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>> >>>>>>>>>>>>>> Dunith Dhanushka, >>>>>>>>>>>>>> Senior Software Engineer - BAM, >>>>>>>>>>>>>> WSO2 Inc, >>>>>>>>>>>>>> >>>>>>>>>>>>>> Mobile - +94 71 8615744 >>>>>>>>>>>>>> Blog - dunithd.wordpress.com <http://blog.dunith.com> >>>>>>>>>>>>>> Twitter - @dunithd <http://twitter.com/dunithd> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> *Tharindu Munasinghe* >>>>>>>>>>>>> Software Engineering Intern >>>>>>>>>>>>> WSO2 Inc.(http://wso2.com) >>>>>>>>>>>>> SRI LANKA >>>>>>>>>>>>> >>>>>>>>>>>>> Mobile: +94 77460887 >>>>>>>>>>>>> E-Mail: [email protected] >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> *Tharindu Munasinghe* >>>>>>>>>>>> Software Engineering Intern >>>>>>>>>>>> WSO2 Inc.(http://wso2.com) >>>>>>>>>>>> SRI LANKA >>>>>>>>>>>> >>>>>>>>>>>> Mobile: +94 77460887 >>>>>>>>>>>> E-Mail: [email protected] >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> *Tharindu Munasinghe* >>>>>>>>>>> Software Engineering Intern >>>>>>>>>>> WSO2 Inc.(http://wso2.com) >>>>>>>>>>> SRI LANKA >>>>>>>>>>> >>>>>>>>>>> Mobile: +94 77460887 >>>>>>>>>>> E-Mail: [email protected] >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> *Tharindu Munasinghe* >>>>>>>> Software Engineering Intern >>>>>>>> WSO2 Inc.(http://wso2.com) >>>>>>>> SRI LANKA >>>>>>>> >>>>>>>> Mobile: +94 77460887 >>>>>>>> E-Mail: [email protected] >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> *Tharindu Munasinghe* >>>>>>> Software Engineering Intern >>>>>>> WSO2 Inc.(http://wso2.com) >>>>>>> SRI LANKA >>>>>>> >>>>>>> Mobile: +94 77460887 >>>>>>> E-Mail: [email protected] >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Architecture mailing list >>>>>>> [email protected] >>>>>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> >>>>>> Dunith Dhanushka, >>>>>> Senior Software Engineer - BAM, >>>>>> WSO2 Inc, >>>>>> >>>>>> Mobile - +94 71 8615744 >>>>>> Blog - dunithd.wordpress.com <http://blog.dunith.com> >>>>>> Twitter - @dunithd <http://twitter.com/dunithd> >>>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Architecture mailing list >>>>> [email protected] >>>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>>>> >>>>> >>>> >>>> >>>> -- >>>> *Tharindu Munasinghe* >>>> Software Engineering Intern >>>> WSO2 Inc.(http://wso2.com) >>>> SRI LANKA >>>> >>>> Mobile: +94 77460887 >>>> E-Mail: [email protected] >>>> >>>> _______________________________________________ >>>> Architecture mailing list >>>> [email protected] >>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>>> >>>> >>> >> >> _______________________________________________ >> Architecture mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >> >> > > > -- > *Tharindu Munasinghe* > Software Engineering Intern > WSO2 Inc.(http://wso2.com) > SRI LANKA > > Mobile: +94 77460887 > E-Mail: [email protected] >
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
