#Dr Spotfire, Renaming of Binned
Dr. Spotfire
I have a binned column that bins item with the following expression.
BinBySpecificLimits([ON_PRODUCTION_YEAR],2014,2015,2016,2017,2018,2019)
On my visualizations the Result looks like this:
x <(or equal to) 2014
2014< x <(or equal to) 2015
2015< x<(or equal to) 2016
etc.
I would like it to output like the following on my visualizations(for example, I am coloring by Binned year):
<(equal) to 2014
2015
2016
etc.
Thanks
Jun 03, 2019 - 12:34pm
stephen.ennis
+ Add a Comment
(1) Answer
In your color axis, you can use custom expression like
<Mid([yrtest],Find("<",[yrtest]) + 4,6)>say yrtest column is the binned column
Extract last 6 characters in your binned string to get specific years
| Attachment | Size |
|---|---|
 capture.png | 7.81 KB |
Feb 03, 2020 - 3:03pm
Khushboo R