Filtering in Subsets

[Stephen Easter]

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!

[Khushboo Rabadia]

You can create 3 custom expressions in that visualization for current month, current year and previous year.

That way you would be able to filter out the data.

It would also be helpful if you can attach your dxp with sample data

[Stephen Easter]

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!