Function “BinByEvenIntervals” is not working as expected. It this a bug in Spotfire?

[Rens Peters]

Dear Spotfire experts,

It looks like the function “BinByEvenIntervals” is not working as expected. It this a bug in Spotfire?
It seems like it always keeps looking at the original data table that is used for the visualizations and not based on applied filters in the visualization.

For the X-Axis I use this function and a date-column to create the analysis. As. Example [Report Date] = dd-MMM-yyyy.

• BinByEvenIntervals([Report Date],2) --> to create two equal bins based on the selected time period.

For the Y-axis I use (Row Count).

• To view the number of rows for the first and second period based on the created bins.

If you apply a filter on the [Report Date] in the analysis. E.g. you select a different time period. Then the Row Count will change (this will reduce for the deselected data). However, the timeperiod for the two bins that are created stays the same. Where I would expect that this will also adjust to the applied filters. Like how it normally behaves for every X-axis time filtering.

No filter is applied: Time period is Aug-23 tot Aug-24

• Expected date in the middle / split between the 2 bins is indeed Feb-24

 

Now filter is applied: Time period is Jan-23 tot Aug-24

• Only the RowCount() changes, but not the X-Axis. It keeps the original bins of the data-table.
• Expected date in the middle / split between the 2 bins stays at Feb-24, but Apr-24 is expected.

 

As mentioned at the top of this post; is this a bug in Spotfire or am I doing something wrong?

Thanks!

[Olivier Keugue Tadaa]

Hi Rens

On the visualization properties, the Category Axis, click settings and  "Current filtered Only" for "Evaluate axis expression on.."

 

 

Let me know if this is what you expected. 

[Rens Peters]

Ah wow. This was indeed the root cause. Really overlooked on that setting. Thanks for the support! 

[Olivier Keugue Tadaa]

No worries; You are welcome