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

17 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

Please sign in to leave a comment.

Didn't find what you were looking for?

New post