cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member

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 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.
Version history
Last update:
‎03-02-2023 09:11 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy