Jump to content
We've recently updated our Privacy Statement, available here. ×

Filtering in Subsets


Stephen Easter

Recommended Posts

Hi,

I'm trying to create an analysis that looks at current month, YTD current year, and YTD prior year. So I'm looking at June data, and it looks like this:

 

 

 

 

 

 

Fiscal June

Fiscal Jan to Fiscal June 2019

Fiscal Jan to Fiscal June 2018

 

 

Customer

 

Current Period

YTD Current Year

YTD Prior Year

 

 

A

Metric 1

99.90%

99.38%

98.63%

 

 

Metric 2

100.00%

80.00%

44.68%

 

 

B

Metric 1

99.81%

99.57%

98.55%

 

 

Metric 2

96.00%

81.21%

40.00%

 

 

C

Metric 1

98.88%

98.97%

97.71%

 

 

Metric 2

55.00%

58.87%

24.24%

 

 

D

Metric 1

99.74%

99.12%

98.04%

 

 

Metric 2

100.00%

55.56%

16.36%

 

 

E

Metric 1

97.62%

97.81%

98.31%

 

 

Metric 2

88.89%

64.81%

89.66%

 

 

G

Metric 1

100.00%

100.00%

99.99%

 

 

Metric 2

100.00%

100.00%

100.00%

 

 

H

Metric 1

99.62%

99.37%

96.71%

 

 

Metric 2

94.12%

87.75%

78.04%

 

 

I

Metric 1

99.46%

99.44%

97.76%

 

 

Metric 2

81.08%

82.13%

17.57%

 

 

J

Metric 1

99.71%

99.51%

98.39%

 

 

Metric 2

80.00%

73.61%

45.59

 

 

 

I've used Subsets in my cross-tab to create the needed dates columns. I'd now like to filter the crosstab to only show selected customers using the filters, so maybe A and C for comparision instead of all of the customers. However, Spotfire is saying that I can't filter when using the subsets in the Axis. Is ther another way to do this other that creating seperate visualization for each time period

Thanks!

Link to comment
Share on other sites

I've added the embedded .dxp file and the excel file just incase.

 

If I create a seperate column for current month, current year to date, and previous year to date I can't get the data to match the subset.  I either have to use a heirarchy in the horizontal axis for each individual column (which looks bad) or a single column in which current year to date doesn't include current month cause the individaul column can either be "current month" or "YTD current year".  Please let me know if there is another solution.

 

 

 

Thanks!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...