3 Replies Latest reply: Mar 22, 2011 2:46 PM by Tresesco B

# Set analysis in TimeChart

I have a time chart to compare Bookings By product to the previous quarter. Problem is I only want to show 4 products. I would normally just change the expression using set analysis. But the way time charts create the graph they use this formula:

Sum(if (InQuarterToDate (Date, Today(), -4),BookedAmount))

The dimension I am using is called product. How can I make this graph only show the three products I am interested in?

I apparently can't change the formula so that {\$<Product = {'Product1','Product2','Product3'}>} )

• ###### Set analysis in TimeChart

Give a try: Normal 0 false false false EN-IN X-NONE X-NONE

Sum( If(Match(Product , 'Product1','Product2','Product3')<>0 AND if (InQuarterToDate (Date, Today(), -4)),BookedAmount))

Regards, tresesco

• ###### Set analysis in TimeChart

Thanks, this worked after I took the extra if out.

if (InQuarterToDate (Date, Today(), -4))

Became just

InQuarterToDate (Date, Today(), -4)

• ###### Set analysis in TimeChart
yes, that was a silly mistake. however, it solved your problem, that is more important.