Comparison field

[Anonymous]

Hi,

I have a chart. I have 2 fields: Campaign and date. (filters)

I want to select from variable Campaign (for example Campaign A) and from comparison variable Campaign (for example Campaign D)  and compare them.

How can I set up independent variables Campaign?

or help with your idea.

Please find attached file.

Thanks,

[MarcoWedel · Accepted solution]

Hi Vladimir,

maybe alternate states could be a solution for you:

at first generate an alternate state like this:

use this state in your comparison campaign selection chart:

add the alternate state to your chart's set expressions:

the result should look like this:

maybe you also have to adjust your set exprsssions in order to let the selections in other fields also apply to your comparison expressions.

see help:

Example:

sum({[Group 1]<Region = $::Region>} Sales)

This syntax uses the selections in the Region field from the default state and modifies the state ‘Group 1’ with them. The effect is to keep the Region field "synchronized" between the default state and ‘Group 1’ for this expression.

hope this helps

regards

Marco

[Anonymous]

It looks like I need it.

But I do something wrong.

Could you please send me your example.

Thanks,

[Anonymous]

I think I solve an issue.

But I use my expression. I don't know how to use your expression.

I have selection by Campaign and/or date.

I'd like to fix my expression. Because when I select from Comparison period, my Campaign period disappears.

I need to re-select date from Campaign period again.