Download: Second Value to Cartesian Charts

Introduction

Today, when you create one of the following charts: Column Chart, Line Chart, Area Chart or Bar Chart, you can add X-Axis, values and Break By. When you set a Break By, there can be only one value presented.

Sometimes it is needed to present more than one value using a break by, for example, showing revenue and quantity divided into years for each age group:

Using the below plugin, you will be able to present 2 values when using a break by.

Steps

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, create it. After unzipping the file, restart the web server.

Step 2 - Create The Chart

1. Create a new cartesian chart. This chart can be one of the following: Column Chart, Line Chart, Area Chart or Bar Chart,

2. Add X-Axis item, Break By item and two Values items.

3. Set the wanted series type for each value, and determine rather the value should be presented on the right y-axis or on the left y-axis*.

4. Save the widget

* The second value to present shows as disabled but it's settings are saved, so in order to change y-axis settings/ series type setting:
1. Enable the value item.
2. Change the y-axis/series type settings
3. Set the value again as disable.

Step 3 - Set the plugin to the widget via the widget script

Edit the widget script with the below script:

prism.SecondBreakByToLineChart(widget, [index_of_the_second_value_to_add],[series_type])

For example:
prism.SecondBreakByToLineChart(widget, 1, "line");

Parameters description:

[index_of_the_second_value_to_add] :
The index of the second value to add. Indexes starts from 0: The first item inside the values panel has index 0, the second value has index 1 etc.
Default index is 1.

[series_type] :
The type of the new value to draw. Available types are:
line, spline, area, areaspline, column or bar.
The default type is taken from the value type itself (within the value menu).

References/Notes

* The plugin works only for column/bar/area/line charts
*After changing the widget type, please click "Apply" and refresh the page
*The second value will be presented as "disable" inside the values panel.
*The plugin does not support the "stack 100" design.
*The plugin works does not support 0 values for categories or x-axis.

Michael Becker May 11, 2017 16:19

Hi Shani,

link is password protected, can we get a not protected version?

Regards,

Michał

Oxana Noa Umansky May 11, 2017 16:24

Hi Michael, thanks!

Please try again, should work now.

Ayanda Dube December 12, 2017 14:44

Hi Oxana,

What if I only want one of my values to be broken down, how do I modify the script?

Gopinath Venkataramanan May 08, 2018 12:54

I have the same question too. I want only one of the values to be broken down, need help

Delsaran Bigglesworth February 27, 2019 13:44

Anyone figured out how to break by just one of the values yet?

Jack Ingoldsby May 01, 2019 05:11 (Edited May 01, 2019 05:23)

Does this work in 7.4? Also can it work for multiple series (actual,average, min, max)

David Hertzberg June 20, 2019 09:13

Looks great ! But I am in 7.4, waiting for update !

Artem Yevtushenko June 20, 2019 13:47

Hey David, I tested the plugin and it works in 7.4.

Business Intelligence October 21, 2019 16:20

I am on 8.0.1 and cannot get this working correctly. The first widget is index 0 yes? I only get the one value (enabled) to show for this widget. Please advise

Business Intelligence October 21, 2019 17:48

drat, ok, I got it to work correctly and I am using line graphs, it there an option to make the line graphs smooth instead of straight?

bundit Nuto June 28, 2020 09:08

Can it support version Version: 8.2.2.10066. I try but it shows only one y-axis.

Second Value to Cartesian Charts