Charting requirement for Canvas

[twu]

Hi all,

I am not sure whether we can do below kind of charting in Canvas?
If yes, please advise how?
If no, can we consider adding to Canvas functionality?

1)Line + Bar Chart, It is very common requirement having the 2nd Y-axis, e.g. Profit/Revenue as Grouped Bar (or) Stacked Bar, where the GP% as line series using the 2nd Y-axis. like below:

2)Sparkling chart, the key point is be able to embed in a table, like below (a sample from C3, so we know it is totally archivable in Canvas, just need to find out how).

3)we know we can use JS library to do map chart, will it be possible to include in Canvas as a chart option?

4)may called “Treemap” or “Heat Map”

Thanks
Tina

[aeremenko]

None of these is part of Canvas. However, it is relatively easy to implement:
For Bar+Line chart, check Angular-nvD3
This library comes with Canvas. Check how they do those charts in JSFiddle. So all you have to do is to create MDX query and process received data in the way required by the chart you want to display.

Sparkline chart is available as plugin: Canvas Plugin: Sparklines

[Vincent]

Hi @twu,

For the map, you can use the map Andrey built:
http://forum.cubewise.com/t/visualisation-with-javascript/121

For the treemap, you can find it in the following post:

Dynamic Treemap

Hi guys, Just to share with you a treemap that Andrey and Ilia built: [image] To make it work with Canvas_sample, you need to add the following rule in the Retail cube: [‘Var %’]= ([‘Budget’] - [‘Actual’]) \ [‘Actual’] ; Please find attached the HTML and controller: treemap HTML Controller.zip (5.4 KB) The treemap needs 2 mdx, one to build the hierarchy and one to get the data. Cheers

Cheers,