Change the display of binned column name in visualization

[David Roynan 2]

I'm wondering if it's possible to change the display name for a binned column in my KPI Chart.

 

For background, I started by inserting a calculated column to find the value for "Days Until Due" ( [Due Date] - DateTimeNow() ). From there, I created a binned column with specific limits: 0;5;15;30;60;90;120. In the KPI chart (and all other visualizations), the result is that it shows xxx< 15 days, etc. I've attached a screenshot.

Is there a way I can change how these appear to show anything

[Andrew Berridge]

Hi David,

Possibly, but you're going to need to get creative!

First of all, create your binned calculation as a calculated column. Here's mine:

BinBySpecificLimits([Prop_clothing],0.2,0.4,1.0)I called it "binned"...

Then I get results from it like this:

x 0.20

0.20 < x 0.40

etc...

So I can now create another calculated column that looks like this:

case when [binned]="0.20 < x 0.40" Then "Between 0.2 and 0.4"

when [binned]="x 0.20" Then "Less than 0.2"

endAnd then I can reference that column from my KPI chart.

Hint - copy each of the cell values from a table plot for the "binned" column.

Andrew (TIBCO Data Science)

Check out my new book on Spotfire!

https://community.spotfire.com/wiki/tibco-spotfire-comprehensive-primer-second-edition-andrew-berridge

[David Roynan 2]

Thanks, Andrew, this worked perfectly!  I was fiddling with similar expressions that I'd found here but none of them worked until this one.  Greatly appreciated.