Trellis Widget

November 22, 2017 21:08

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

Comments

16 comments

Assaf Fraindlich November 23, 2017 06:54

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

1

Permalink
Eric Pouliot December 08, 2017 21:35

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

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

Thanks again!

0

Permalink
David Hertzberg December 18, 2017 16:12

Really cool !

1

Permalink
Eric Pouliot January 07, 2018 04:14
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

Permalink
Takashi Binns January 19, 2018 22:00

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

Permalink
Eric Pouliot January 25, 2018 13:37

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

0

Permalink
David Hertzberg January 26, 2018 09:28

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

Permalink
Robert Choquette January 30, 2018 21:44

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

Permalink
David Hertzberg January 31, 2018 17:31

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

0

Permalink
Matthew Tarricone March 16, 2018 16:02

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

1

Permalink
Robert Choquette May 11, 2018 16:04

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.

0

Permalink
Jeremy Naiden May 17, 2018 16:37

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

Permalink
Robert Choquette June 01, 2018 21:20

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

0

Permalink
Jeremy Naiden June 26, 2018 21:25

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

Permalink
Admin July 20, 2018 08:24

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

0

Permalink

Artem Yevtushenko December 06, 2018 15:15

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'); 
});

Please sign in to leave a comment.

STEP 1 - ADD THE PLUGIN

STEP 2 - CREATE THE CHART

STEP 3 - FORMAT THE CHART

REFERENCES/NOTES

Comments

Didn't find what you were looking for?