Advanced Conditional Palette

[maxchuie]

I have a chart that has a series and categories. my customer wants only the categories is by Quarters and the series is Paid they want Quarter 1 to be a completely different color combinations from the other quarters.

Would I use an If statement if so how would I word it in the advanced condition?

TIA

[Lynn]

I have a chart that has a series and categories. my customer wants only the categories is by Quarters and the series is Paid they want Quarter 1 to be a completely different color combinations from the other quarters.

Would I use an If statement if so how would I word it in the advanced condition?

TIA

You didn't say whether you've got a relational package or a dimensional package or what identifies the first quarter.

Assuming that you've got a query item in a relational package that indicates quarter number:

Click on the series to expose the bar properties.
Scroll down to find the Conditional Palette property.
Create a new advanced condition.
Add a condition as [YourQuery].[Your Quarter Number] = 1
Style for whatever color is desired for quarter one.

If you have a dimensional package then the method for identifying the first quarter might be different.

[maxchuie]

Yes it is Dimensional data

[maxchuie]

Does anyone know how to do this in dimensional?

[Lynn]

Yes it is Dimensional data

Does anyone know how to do this in dimensional?

Can you share anything at all about your date dimension? Do you have an attribute that identifies the quarter number? That would be the easiest way to do exactly what I already described. Just drag it into your query, associate it through the "properties" property for your chart node and use the conditional palette expression as before.

Attached is a report using the GO Sales (analysis) package that implements this.

If you don't have a quarter number attribute then you'll need to extract it from your MUN but it is difficult to help until you can describe how your date dimension is structured and what the MUN looks like.

[maxchuie]

Thank you Lynn..
I am still having trouble. I have 4 series color bars in each Quarter and I need each of those series color bars in Q1 to be a different color I tried a condition and bringing in each one as individual color in the conditional pallet It does not work. as my attached pic...

I need each bar in PaidQ0 different colors

[Lynn]

Thank you Lynn..
I am still having trouble. I have 4 series color bars in each Quarter and I need each of those series color bars in Q1 to be a different color I tried a condition and bringing in each one as individual color in the conditional pallet It does not work. as my attached pic...

I need each bar in PaidQ0 different colors

I don't see any attachment but even so you'll probably still need to explain what your date dimension looks like, how the MUNs are constructed, and whether or not you've got a quarter number attribute for your quarters, unless your missing attachment illustrates all those things.