The Chart Label Order Changer

[intapiuser]

Download: Change Labels

Introduction

The Label Changer is efficient when wanting to order text values in a specific order which is not alphabetical order.

For example: Ordering Week days names as  : Sunday, Monday… or Month names as: January, February etc…

The plugins works with multiple values on Bar Chart, Column Chart and Line Chart. The plugin also supports break by.        

Steps

In order to add the Label Changer plugin, please follow the listed steps below:

STEP 1:

Create a custom field in the EC that has the desired values with numbers at the start. Each value will begin with the ordered number (The first one with ‘01’ ) and the desired text to present in the dashboard.

Examples:

 For the days of the week use this text:

CASE WHEN DayOfWeek(Date) = 1 THEN '01Sunday'
WHEN DayOfWeek(Date) = 2 THEN '02Monday'
WHEN DayOfWeek(Date) = 3 THEN '03Tuesday'
WHEN DayOfWeek(Date) = 4 THEN '04Wednesday'
WHEN DayOfWeek(Date) = 5 THEN '05Thursday'
WHEN DayOfWeek(Date) = 6 THEN '06Friday'
WHEN DayOfWeek(Date) = 7 THEN '07Saturday'
ELSE ''
END

For the Month Names use this text:

CASE WHEN getMonth(Date) = 1 THEN '01January'
WHEN getMonth(Date) = 2 THEN '02February'
WHEN getMonth(Date) = 3 THEN '03March'
WHEN getMonth(Date) = 4 THEN '04April'
WHEN getMonth(Date) = 5 THEN '05May'
WHEN getMonth(Date) = 6 THEN '06June'
WHEN getMonth(Date) = 7 THEN '07July'
WHEN getMonth(Date) = 8 THEN '08August'
WHEN getMonth(Date) = 9 THEN '09September'
WHEN getMonth(Date) = 10 THEN '10October'
WHEN getMonth(Date) = 11 THEN '11November'
WHEN getMonth(Date) = 12 THEN '12December'
ELSE ''
END

 Status sorting:

CASE 
WHEN Status LIKE 'Fail' THEN '01Fail'
WHEN Status LIKE 'Medium' THEN '02Medium'
WHEN Status LIKE 'AboveAverage' THEN '03AboveAverage'
WHEN Status LIKE 'High' THEN '04High'
WHEN Status LIKE 'Amazing' THEN '05Amazing'
ELSE ''
END

STEP 2:

DOWNLOAD AND EXTRACT THE ENCLOSED CHANGELABELS.RAR ZIP FILE INTO THE PLUGINS FOLDER:

C:\Program Files\Sisense\PrismWeb\plugins\, if the "plugins" folder is not there, please create it. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. 

Step 3:

Edit config file under: (Right Click and Edit with Notepad ++)

C:\Program Files\Sisense\PrismWeb\plugins\ChangeLabels\config.js

Add the Custom fields (You can create more than one) you created to the dimensionsToChange with as:

["[TableName.FieldName]"]

For Example:

var dimensionsToChange = ["[Commerce.DayofWeek]","[Commerce.MonthName]"];

Step 4:

Create a chart with the custom field you created. Press Apply.

Refresh the dashboard and the values will appear without the numbers.

Example of the Plugin with DayofWeek field break by Age Range:

General Note: This plug-in actually removes the first 2 characters from the values of the field in the web display but maintains the order of the values according to the 01 / 02 / 03 etc. 

In case you have values that begin with numbers please add 1. / 2. / 3. etc. to the beginning of the values (instead of 01 / 02 / 03).