Trellis Widget

Follow
Avatar
Takashi Binns

Download: trellis.zip

Version: 1.1

This article explains how to create a trellis chart using Sisense.  This is helpful for showing a dynamic number of charts, based on your data

Steps

The following steps will walk through the process of adding the new chart type and creating a sample trellis chart.

STEP 1 - ADD THE PLUGIN

Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, just create it.  After those files have been unzipped there, you may also have to restart the web server. 

STEP 2 - CREATE THE CHART

On your dashboard, create a new widget and select Trellis as the type.  Fill in the panel items based on the descriptions below.

  • axis - For each chart, use this dimension for the axis or category.  You can leave this empty, when displaying indicators
  • value - The metric to use for drawing the charts.  If no color value is supplied, the chart colors come from this item
  • color - Optional panel, in case you want to color the charts by a different metric than the value.
  • split by - This panel is how you get multiple charts.  If your dimension has 4 unique members, the widget will build 4 charts.

STEP 3 - FORMAT THE CHART

This visualization has several formatting options, see below for a description of each.

  • Chart Size - A slider control that allows determines how big to make each chart.
  • Chart Type - Determines what kind of visualization should be created 
  • Label Location - Where to place the the Split By label (pie chart only allows for top/bottom, and this is not applicable for Number chart types)
  • Value Axis - Decide whether to show more details on the chart (Not applicable for Number chart types)
  • Aspect Ratio - Depending on the chart type, you may want to use a different aspect ratio (1:1 for pie, 16:9 for bar, etc)

REFERENCES/NOTES

  • When displaying indicator as the chart type, if you include an axis dimension only the first result will be displayed.
  • UPDATE Dec 7, 2017 - Changed the renderer to Highcharts for easier formatting of charts.  Also added in column/bar charts as additional types.
  • There is a known issue with exporting to PDF, we will update the post when it is resolved.
  • Version 1.1: Added line chart as a new option, fixed alignment issue when using long titles, added vertical scrolling when the widgets don't fit
5

Comments

20 comments

Sort by Date Votes
  • Avatar
    Assaf Fraindlich

    Wow, that is a powerful visualization yet so simple! Thank you.

    1
    Comment actions Permalink
  • Avatar
    Eric Pouliot

    Hi Takashi! Quite pleased to see this plugin! Thanks!

    Would you consider also adding the line chart to the options? 

    Thanks again!

    0
    Comment actions Permalink
  • Avatar
    David Hertzberg

    Really cool !

    1
    Comment actions Permalink
  • Avatar
    Eric Pouliot

    Hey Takashi,

     

    This visualization is really great. Do you plan releasing more updates to it?

    Couple feedback items:

    • Can you add line chart as an option?
    • Can you support palettes for the charts? For example, all slices in a pie chart have the same 1 color. You can create a color range but not the same control as palettes.
    • Indicator formatting is uneven. See screen below.
    • Can you add scrolling to visualization? If the number of charts exceed the allotted space, I can't scroll to see the rest of the charts. See example below.

    Thanks!

     

    Indicators:

    Scroll

    0
    Comment actions Permalink
  • Avatar
    Takashi Binns

    Hi Eric,

    I've added lines as a new chart type, and fixed some of the issues you mentioned above.  The only one not addressed was adding a color palette option to this widget.  This would be a cool option, but its a pretty involved feature request.  We'll keep it in mind for future releases.

    thanks,

    -Takashi

    0
    Comment actions Permalink
  • Avatar
    Eric Pouliot

    Hey Takashi, this is a much nicer iteration, thanks for putting some love into this visualization. Fingers crossed it continues to receive attention :)

    0
    Comment actions Permalink
  • Avatar
    David Hertzberg

    Hi, great plugin !

    But it looks like it is incompatible with JAQLine plugin : when JAQLIne is activated, the treillis widget does not appear in the drop down list when creating a widget. It is back when I deactivate the JAQLine. Any chance they could work together ?

    Best,

    David.

    0
    Comment actions Permalink
  • Avatar
    Robert Choquette

    This is a great plugin!  Thanks for doing this.  One request. Could you please add a 20:5 aspect ratio to the list of options to allow for shorter graphs (ie when you have a larger number of "spilt by" data points.

    I made this change locally and it looks great.

    Cheers,

    Robert

    0
    Comment actions Permalink
  • Avatar
    David Hertzberg

    Regarding compatibility with JAQLine : my mistake ... I was not using latest version of JAQLine widget ...

    0
    Comment actions Permalink
  • Avatar
    Matthew Tarricone

    Do we know if this is working in 7.0? Tak? 

    1
    Comment actions Permalink
  • Avatar
    Robert Choquette

    I am using this on 7.1.1 and it works well.  There is a small issue where the number formatting isn't respected.  Maybe someone could take a look at resolving that.

    1
    Comment actions Permalink
  • Avatar
    Jeremy Naiden

    Great plugin!  Unfortunately on Sisense v 7.1, after I add a "Split By" field, I am no longer able to click "Apply" .  I've tested on Mac and PC with ad blocking software enabled and disabled.  Not sure if this affects other versions but any ideas for a fix are appreciated!

    0
    Comment actions Permalink
  • Avatar
    Robert Choquette

    Circling back around, I worked around the number formatting issue by using a round() function in a formula on the data.

    0
    Comment actions Permalink
  • Avatar
    Jeremy Naiden

    Is anyone else having issues exporting to pdf/printing the trellis chart?  Regardless of what browser or OS I try, I can't seem to get it to print/export.

     

    Thanks!

    Jeremy

    0
    Comment actions Permalink
  • Avatar
    Admin

    Would it be possible to make it visible in pdfs? :) in 7.1 seems to be invisible :) Thanks!

    0
    Comment actions Permalink
  • Avatar
    Artem Yevtushenko

    You can center the widgets in the widget rectangle by using this script:

    widget.on('domready', function(a,b){ 
     $('.trellis').css('margin-left','20px').css('display','inline-block').css('float','none'); 
     $('.d3-trellis').css('text-align', 'center').css('margin-bottom', '0'); 
    });
    2
    Comment actions Permalink
  • Avatar
    Greg Mcgee

    I love this plugin.  However I cannot get the Value to show Currency in the $M format.

    0
    Comment actions Permalink
  • Avatar
    Shanky Balani

    I've created a dashboard using this widget. It works on my end but when I share it with internal users they are not able to pull up the dashboard. It appears their list of dashboards off to the left disappears. Also when clicking into the dashboard, no data renders. Any one else run into this?

    Thanks.

    0
    Comment actions Permalink
  • Avatar
    Dmitry Shubin

    How do I fix my PDF display problem?

    0
    Comment actions Permalink
  • Avatar
    Nadir Islam

    How can I sort the bar chart in this trellis chart by value?

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post