Bar chart with Trellis--How to remove categories that are filtered?
The question is regarding the top bar chart.
I used Trellis tab in Properties to divide among AL and NL. As you can see, the values of the team that belong to the other league were filtered, and yet there still is an empty space allotted for the filtered columns. How to I remove the filtered columns, and display only the categories that are relevant?
So basically I do not want any empty spaces for each AL and NL chart.
Thank you
Solution
This is how Trellis works. If you want them completely separated create two separate bar charts and limit the data using expressions, or apply a custom filtering scheme. The first option is the simplest and is my preferred method.
- Right Click > Properties > Data > Limit Data Using Expressions > Edit
- Expression:
[leagueColumn] = 'AL'or if you want to be explicit, yet have the same effect,if([leagueColumn] = 'AL', TRUE, FALSE)
Do this for the other chart, using NL as well.
- Spotfire bar chart with variable amount of columns used for category axis
- On-demand loading in combination with modified SQL in information link
- How to update a label control in Spotfire with a matched data table column value when a drop-down filter control changes?
- Replace double quotes with blank space in Tibco Spotfire
- Earlier and Latest date of two columns
- Spotfire Table Visualization column width
- Spotfire- Scatterplot Line Connection Issue
- Spotfire and Regex- Extracting Several Values Stored in One Column
- How to find the consecutive values in a column based on another group column
- SpotFire - taking the average value over 90 days using only non zero values
- SpotFire - Sum up values over multiple Columns
- SpotFire - return data within two time intervals
- Spotfire and BigQuery
- How to Reload Individual Data Operations in TIBCO Spotfire Using IronPython Scripting
- Spotfire Date Ranks Incorrectly
- Adding multiple columns in a spotfire custom expression
- SytemError when trying to run progress bar when executing a script in spotfire
- Calculate the count of yes/no in multiple columns
- Difference between two row values within the same column based on value in third column in R
- Spotfire: DataFunctionError: Output variable was not defined
- Spotfire ironpython replacing data table values
- Compare two months from two different years in a bar chart
- Calculating daily average count of each category in Spotfire when some categories do not appear on every day
- How to get values from all the columns of the table in Spotfire using IronPython
- How to set a filtering scheme to data function input via ironpython?
- How can I draw a curve based on expression via ironpython?
- Why can I not cast my filter as listboxfilter in ironpython?
- How To Toggle Lines & Curves Names Visibility On Spotfire With Iron Python?
- Spotfire : Load already created pickle file from data function in spotfire
- calculate cumulative sale/production in calculated columns