Category: Charts and Data Visualization

See: https://tiki.org/forumthread51287
---
Addendum: Make a plugin in Tiki to display the basic d3.js-based charts already developed in the past (in through PluginChart or other means)

Related: https://dev.tiki.org/item6263 - Make PluginChart optionally reuse some other lib already in Tiki to make js-based charts (raphaeljs, chartjs, d3.js, etc)

See:
https://dev.tiki.org/Data+Visualization#d3.js

Basic d3.js-based charts already made in Tiki:
http://marclaporte-11197-5155.show.tikiwiki.org/
u: admin
p: 12345

Export Spreadsheet as csv with code to produce svg chart includes the svg output tags in the csv cell instead of the tiki syntax to generate the chart

Reproduced when attempting to export sheet4 in doc.t.o, which is part of the sample charts generated from the tiki spreadsheet feature:
https://doc.tiki.org/tiki-export_sheet.php?sheetId=4

When exported (as csv with comma, and utf8) the content is like:
{CODE(colors="htmlmixed")}
Chart Type,Example,Chart,Data,Month,Year
Vertical Bar,"=BARCHART(D2:D13),<div class="jSheetChart"><svg height="172" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M80,139L58,139L58,127L80,127Z" stroke="none" fill="#1751a7"></path><path d="M108,139L86,139L86,1,4,Jan,2001
Horizontal Bar,"=HBARCHART(D2:D13),<div class="jSheetChart"><svg height="148" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M53,27L53,20L95,20L95,27Z" stroke="none" fill="#1751a7"></path><path d="M53,36L53,29L116,29L116,,6,Feb,2002
Pie,"=LINECHART(D2:D8, F2:F6)",<div class="jSheetChart"><svg height="220" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><text fill="#000000" stroke="none" font="12px Arial, sans-serif" style="text-anchor: middle; font: 12px A,7.2,Mar,2003
Line,"=PIECHART(D2:D8, E2:E8)",<div class="jSheetChart"><svg height="144" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path stroke-linejoin="round" stroke-width="1" style="stroke-width: 1; stroke-linejoin: round;" d="M210.5,7.5,Apr,2004
,,,8.2,May,2005
,,,9.1,Jun,2006
,,,14.1,Jul,2007
,,,16,Aug,2008
,,,17.9,Sep,2009
,,,22,Oct,2010
,,,30,Nov,2011
,,,32,Dec,2012
,,,,,
,,,,,
{CODE}

And in my honest opinion, it should be something like:
{CODE()}
Chart Type,Example,Chart,Data,Month,Year
Vertical Bar,"=BARCHART(D2:D13)",=BARCHART(D2:D13),4,Jan,2001
Horizontal Bar,"=HBARCHART(D2:D13)",=HBARCHART(D2:D13),6,Feb,2002
Line,"=LINECHART(D2:D8, F2:F6)",=LINECHART(D2:D8, F2:F6),7.2,Mar,2003
Pie,"=PIECHART(D2:D8, E2:E8)",=PIECHART(D2:D8, E2:E8),7.5,Apr,2004
,,,8.2,May,2005
,,,9.1,Jun,2006
,,,14.1,Jul,2007
,,,16,Aug,2008
,,,17.9,Sep,2009
,,,22,Oct,2010
,,,30,Nov,2011
,,,32,Dec,2012
,,,,,
,,,,,
{CODE}

Expose ((doc:Action log)) data to the pivottable plugin. Some data can be seen through ((doc:Activity Stream)) feature, but it seems it only allows to display tracker item events, and something related to socialnetworking.

I don't know whether this means exposing the action log data to the unified search index or not, but exposing the activity in the site to admins to easily review and visualize with some charts and summary tables what's going on would be very helpful.

Reproduced here:
http://stirus-11828-6082.show.tikiwiki.org/tiki-sheets.php
u: admin
p: 12345

I tried the following:

1-created a spreadsheet with two columns; row one had headings, row two data
* http://stirus-11828-6082.show.tikiwiki.org/tiki-view_sheets.php?sheetId=1
2-exported the spreadsheet in CSV format, UTF-8 character set
3-renamed the export file
4-edit the exported file with UltraEdit; changed one field; saved with UTF-8
5-created an empty spreadsheet
* http://stirus-11828-6082.show.tikiwiki.org/tiki-view_sheets.php?sheetId=2
6-ran import CSV with UTF-8
7-no data imported, and the sheet just says "Array".

The Mathematical Calculation Tracker Field type should be improved in a way to be able to use Javascript and/or PHP code elements for calculations
(in fact maybe all areas where currently the mathematical calculation logic is used in Tiki could be improved by including Javascript and/or PHP).

This would greatly improve the possibilities and power of Tiki and Trackers to include more advanced calculation and logic into the Tiki system.

I've made a page to display the ((Bug report evolution|Bug report evolution)) over time in dev.t.o, thanks to PluginPivotTable and dereived attributes of the dates, etc.

Charts are displayed, But the chart width seems to be hardcoded to 600px or similar, even if the PivotTable plugin params said width=100% initially, and I forced them to width=1000px, but no change. And in real world scenarios, with long dataset (like in the tiki community with the bug tracker :-) visualization is too concetrated.(and I did not find an easy way to make a quarter aggregation of items, but that's another topic)

Searching a bit, this seems to be an issue already identified in other implementations of pivottable.js in other softwares:
https://github.com/nicolaskruchten/pivottable/issues/848

An easy solution/workaround might involve maping param rendererOptions inside pivottable .tpl (to set plotly width and height) to to the width and height indicated in the pivottable tiki plugin params.
See:
https://pivottable.js.org/examples/scatter.html
{CODE()}
...
rendererOptions: { plotly: {width: 600, height: 600} }
...
{CODE}

Probably below this chunk of code in wikiplugin_pivottable.tpl (lines 411-51) in trunk:
{CODE()}
...
{{if $pivottable.heatmapParams}}
rendererOptions: {
heatmap: {
colorScaleGenerator: function(values) {
return Plotly.d3.scale.linear()
.domain({{$pivottable.heatmapParams.domain|json_encode}})
.range({{$pivottable.heatmapParams.colors|json_encode}});
}
}
},
{{/if}}
...
{CODE}

Make PluginChart optionally reuse some other lib already in Tiki to make js-based charts (raphaeljs, chartjs, d3.js, etc)

By default PluginChart was able to produce these charts:
https://doc.tiki.org/Spreadsheet+Graphics+and+Charts#Select_the_Graphic_Type_and_Output_Format

But it would make total sense to have the option to produce js-based or svg-based charts, like the ones currently produced by the Spreadsheet js feature ( , reuing raphael.js lib), or the ones in theory available in the ((doc:PluginChartJS)) plugin and lib.

Strategic feature to get Spreadsheets and charts out of them in the game again.

There is another request to have the png & jpg versions of the charts produced again (they are currently not shown), since this implies an easy solution for charts in PDF reports working automagically without requiring complex solutions to get js-based charts incluided in PDF reports.
This request, though, is to have an some optional parameter added to get the chart produced with some JS lib already in Tiki like the ones cited above. And we will see elsewhere how to ensure that they can be included in the printed PDF, etc.

Page with many PluginSheet calls should respect their own uses of parameter 'simple=y/n'

How to reproduce:
Apply profile ((pr:Spreadsheet demo)), and at the instructions page, many sheet plugin calls have -+simple=y+-, and only one has -+simple=n+-. However, all of the sheet plugin calls in the page inherit the -+simple=n+-

----
See it reproduced here:
Compare the page produced by the profile:
http://xavi-9794-6265.show.tikiwiki.org/tiki-index.php?page=Spreadsheet-demo-instructions
u: admin
p: 12345

with an equivalent page where all sheet plugins where set to simple=y:

http://xavi-9794-6265.show.tikiwiki.org/tiki-index.php?page=Spreadsheet-simple-only

http://xavi-9794-6265.show.tikiwiki.org/tiki-pagehistory.php?page=Spreadsheet+simple+only&newver=0&oldver=2

Please note the different UI surrounding all sheets in the earlier version (the one also coming from the profile: all simple=y but one simple=n )

Pivottable allows to use activitystream as source data.

This offers the field modification date (day)
Pivottable usually wants to aggregate data for charts or tables to be meaningful, and that requires the aggregation of single data points overt common time frames: weeks, months, etc

It would be very useful if there was some way to let the user display activity stream data over weeks, months, etc.

With tracker data, you can do a workaround with a mathematical calculation field and using the Calculation syntax to get the week or month from a date field, etc. But with activity stream, I don't get how to achieve that.

This is going to be very useful for Tiki site admins to find insights on how their users are makeing use of their tiki sites over time.

Reproduced here:
http://xavi-9794-6803.show2.tikiwiki.org/tiki-index.php?page=Profile_Activity_Stream
u: admin
p: 12345

PluginChart doesn't produce the expected chart, just the legend

Try to reproduce the example at the documentation, and you'll get the issue reproduced, like in the https://doc.tiki.org/PluginChart

Strategic feature to get Spreadsheets and charts out of them in the game again.

^__Please note:__
This request is to have the png & jpg versions of the charts produced ( see: https://doc.tiki.org/Spreadsheet+Graphics+and+Charts#Select_the_Graphic_Type_and_Output_Format ), not some js based solution (like reusing raphaeljs or chartjs lib, etc.), since this implies an easy solution for charts in PDF reports working automagically without requiring complex solutions to get js-based charts incluided in PDF reports. A different request/wish will be added to add some optional parameter to get the chart produced with some JS lib already in Tiki like the ones cited above.
^

When you set up in ((doc:PluginPivotTable)) the renderName from __HeatMap__ to __Table With Subtotal Heatmap__, then when you click on a cell produces no popup with the aggregate details any more.