Custom Chart Options (plugin to easily apply Highcharts configuration using json)
Download: Custom Chart Options
Version: 1.0.0
Created Oct-23-2019 by Steve Lewis (thanks to code re-used from Elliott Herz's Custom Bar/Column chart plugin)
Current Version: V1.0.0
Tested on Sisense Version: V8.0.1.10112
Description:
Sisense allows a certain level of chart customisation via the user interface out of the box.
However, it's also possible to use the Highcharts API to make additional changes
(For example, changing the background colour, axes etc.) through custom javascript via the
'edit script' panels of widgets.
But - this requires some developer skills, and isn't so convenient for updating multiple properties at the same time.
This plugin offers a user interface to be able to edit, preview and save a custom chart configuration (Json document) that follows the Highcharts API documentation
It includes and uses an open source Json Editor
Instructions:
1) Unzip contents and copy plugin folder to /<sisense_plugins_folder/customChartOptions (e.g. C:\Program Files\Sisense\app\plugins\customChartOptions on windows deployments)
2) Create/Edit a compatible widget (Bar, Column, Line, Area, Pie)
3) Activate "Custom Options" toggle on the Design Panel and click the 'Edit Custom Configuration' button.
4) Click the 'Example Config' and then 'Save & Preview' buttons to see an example of customising a chart. Use the Json Editor user interface and Highcharts API Documentation to customise the chart settings as desired.
5) Chart configuration is saved to each widget, and merged with the other chart options applied by Sisense as the chart is drawn. Therefore you only need to specify those things you want to change, not the entire chart options.
Quick demo using the plugin:
Limitations:
1) It's likely possible for some strange combinations e.g. choosing a bar chart in Sisense, then changing to a line chart via the custom options.
2) To be discovered
-
Official comment
Thanks all, I'm glad it's useful!
For now please request access to the file if you cannot access it, and I'll approve the request ASAP.
Meanwhile I'm working with our G-Suite admin to try to resolve the issue, which is preventing me from making it public at the moment.
Tripti Jaiswal That's strange, it's still working for me on all those chart types in 8.0.2.10024
I will update soon to add scatter plots (missed that one) but the others should work - can you check you don't need to scroll down the panel on the right hand side (in case it's hidden?) And if it's still not there try a hard refresh in the browser in case caching is an issue. Let me know how you get on.
Comment actions -
Was exploring the plugin in Version: 8.0.2.10023.It's really nice!
Currently its working for widget Bar & Column.
But 2nd point in Instruction says Create/Edit a compatible widget (Bar, Column, Line, Area, Pie).Hope we will get the updated version for all these widget type soon.
Thanks
Tripti
-
Hi Steve,
This plugin looks very nice !
However i don't have the access to download the plugin on google drive..
Could you please give the access to mariehelene.seyer@gmail.com ?
Thank you in advanced !
-
Steve Lewis I've looked at the javascript briefly, and I couldn't find anywhere to access the highcharts options. I imagine it is there, I just didn't know where to look. This broke 4 other community plugins I was looking at as well, so I think they all have the same issue.
If you find a solution Steve, that would be great.
Morgan
-
Morgan Everett I just tried it on Sisense 8.1.3.11001 - Service Pack- March 24, 2020 .. seems to be working OK.
Can you confirm your full version number? If it's this version, are there any relevant errors in the browser console?
-
There is nothing similar at the moment but we have developed something similar that will be launched to the marktpace soon AND will be officialy supported by our Presetnation Builder as well.
It will be free of charge. Let's discuss it on our next meeting.
Cheers
Ravid
-
Ravid Paldi You mentioned that this Pivot colouring will be available sometime soon. Really keen on having a look at it. Do you have any details when it will be available?
-
Admin (I'm not sure I tagged the right user, if not then appolgies (: )
We actually paused that development as we are focusing the development of those capabilties on the new pivot2 widget which is already avaialble in the Linux version and soon to be launched to the windows version as well.
If there is an urgency, Send me a mockup of thing you wish to change and I'll give you few tips on how to make it happen in the mean time
I hoep it helped,
Ravid
-
@Steve Lewis . Hi Steve,
The plugin looks great!
Can you please provide access to HemlataMingwal2015@gmail.com . It would be great help.
Much Thanks,
Hemlata -
I've found an issue with the Custom Charts plugin in version 8.2.3 of Sisense. It appears to break the functionality in the admin site with the new Look & Feel option. If try to restore to default the look and feel options, the pop up never appears. After I disable the custom charts plugin it now works, I did some troubleshooting with Sisense, and that custom charts plugin appears to be the issue.
I was wondering if you have been able to test it on 8.2.3, or if i have another plugin that is working with custom charts to cause the issue.
Thank you.
Please sign in to leave a comment.
Comments
22 comments