Reputation: 75
I need to use PG_Fiscal Quarter(Date(2015,10,1)) to make quarter 1. Similarly by putting four other starting dates in the fiscal quater I need four quarters in one bar graph. How can i have that. i cant simply assign them in custom expression
Upvotes: 0
Views: 90
Reputation: 23598
As @niko said, this is almost the same as your previous question. But basically you want show your data with 4 quarters in your bar chart.
In that case, do not make 4 variables, but make 1 date variable and let spotfire do the splitting in quarters. This is a standard functionality in spotfire to create date hierarchies.
On your category axis you can select the date and set this to quarters. Spotfire will then show all the quarters in your date. This also opens up the possibility to use the standard expression like year to date, difference, etc.
Upvotes: 2