Hi Seshika, What I did was , transformed the data set according to your requirement and used the existing functions. The existing functions apply colors to individual columns/rows. Have to add a function to apply colors for entire data-set.
Thanks, On Sun, Mar 29, 2015 at 3:31 PM, Seshika Fernando <[email protected]> wrote: > 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] >> > > -- *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
