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
