Visualizations show different colors in different regions
Article ID: KB0079978
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 7.5 and above |
Description
Bar chart, KPI chart etc. shows different colors when analysis is opened up in different regions. For example, this is the original visualization which needs to be seen by other users as well
This is the visualization seen by users having portugese set as their preferred language on browser
Colors seen in visualizations depends on the data flowing through the analysis if they are based on conditional rules. If the colors are setup manually through color scheme or by setting the color based on values, that will again depend on data flowing. This generally happens when you are binning the column like BinBySpecificLimits, BinByEvenIntervals, BinByEvenDistance etc.
Suppose you have Age column of real format and you create calculated column binning that Age column, so the values will be as below:
Now, this binned column is added in ColorAxis with unique values in Colormode and colors setup as follows:
The above color settings have been done while the values of binned column were in English locale i.e. locale having decimals as ".". So if you open the attached dxp in any browser whose language locale specifies decimals in dot notation, you will see the colors as above. If the same analysis, you open in a browser whose preferred language is portugese where decimals notation is comma, you will see different colors
This is the visualization seen by users having portugese set as their preferred language on browser
Colors seen in visualizations depends on the data flowing through the analysis if they are based on conditional rules. If the colors are setup manually through color scheme or by setting the color based on values, that will again depend on data flowing. This generally happens when you are binning the column like BinBySpecificLimits, BinByEvenIntervals, BinByEvenDistance etc.
Suppose you have Age column of real format and you create calculated column binning that Age column, so the values will be as below:
Now, this binned column is added in ColorAxis with unique values in Colormode and colors setup as follows:
The above color settings have been done while the values of binned column were in English locale i.e. locale having decimals as ".". So if you open the attached dxp in any browser whose language locale specifies decimals in dot notation, you will see the colors as above. If the same analysis, you open in a browser whose preferred language is portugese where decimals notation is comma, you will see different colors
Issue/Introduction
Visualizations shows different colors in different regions
Resolution
As per the expectation, the analysis should be same across regions but this behavior is as per design. If unique values in column change, corresponding colors will also change.
You can use either of the below approach to achieve the desired result:
1) You can use segments, gradients, fixed in color mode instead of unique values
2) If you still want to use unique values only then in current scenario Age column which is in real format can be converted to Integer and then binned column be created using that integer column like BinBySpecificLimits(Integer([Age]),3,6,9,12)
You can use either of the below approach to achieve the desired result:
1) You can use segments, gradients, fixed in color mode instead of unique values
2) If you still want to use unique values only then in current scenario Age column which is in real format can be converted to Integer and then binned column be created using that integer column like BinBySpecificLimits(Integer([Age]),3,6,9,12)
Additional Information
Attachments
Feedback
Yes
No
Powered by
