conditional line style/color

[jduenyas]

Hi all

In my Dimensions > Available Fields/Groups I have a cyclic group that contains 'Periods' (months/days...) and 'Sales-people' as the 2 alternates.

When plotting a line chart against 'Period' dimension, it makes sense to view the chart as a line (and symbol) as it is a continuous dimension. However when selecting 'Sales-People' as dimension, a line chart makes no sense and should be either Column or line with Symbol where only the Symbol is viewable.

Is there a way to show the chart, when 'Sales-People' is the dimension,  and hide the line while showing only the Symbol?

Your help is appreciated.

Thanks

Josh

[jonathandienst · Accepted solution]

If you use a combo chart, you can create two expressions and display the one with a line and one with bars, and then use conditional display on the expressions dialog to switch between the two. The GetCurrentField() function will allow you to determine which option is selected in the cyclic.

[jduenyas]

Bravo!

Thanks a lot. Nice solution.

[jduenyas]

Works beautifully