Rolling quarters

TIBCO Spotfire Community » TIBCO Spotfire » TIBCO Spotfire Developer » Rolling quarters

Last post Mon, Aug 2 2010 6:13 AM by sudhakar. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

Fri, Jul 30 2010 5:18 AM

sudhakar
Joined on Fri, Jul 30 2010
Posts 8

Rolling quarters

Reply Contact

Hi All,

I have a column called quarter and another column called sales. I want to have rolling quarters in X axis. Example For 2010 till now Q1 and Q2 data available.If I create the bar chart it should show Q3,Q4 of 2009 and Q1,Q2 of 2010 in x -axis and sales in Y-axis. When the next quarter data of 2010 loaded the report should be automatically updated with Q4 of 2009 and Q1,Q2,Q3 of 2010. Can we do this using custom expression or any other way is there. PLease help me.

Thanks in advance

Fri, Jul 30 2010 9:57 AM In reply to

Christof
Joined on Mon, Feb 18 2008
Germany
Posts 1,081

Re: Rolling quarters

Reply Contact

Hi,

Search the Help for "Advanced Custom Expressions".

There you will find how to use the "LastPeriods" statement like this one here:

Sum([Sales]) OVER (LastPeriods(4, [Axis.X]))

Christof

-----------------------------------
Dr. Christof Gaenzler
Sr Solutions Consultant
TIBCO Spotfire

Filed under: over

Mon, Aug 2 2010 6:13 AM In reply to

sudhakar
Joined on Fri, Jul 30 2010
Posts 8

Re: Rolling quarters

Reply Contact

Thanks Christof. Your code helped me a lot. Thanks once again.

Page 1 of 1 (3 items)

Spotfire's interactive information visualization and analytic solutions give users a remarkable experience for quickly and easily querying data and reporting results for superior business intelligence. From portfolio management and customer retention programs to key processes such as CRM, marketing, research, bioinformatics, yield and asset management and design for manufacturing, enterprises around the world rely on Spotfire's business analytics software to improve operational performance.