Graphical help

[samvile18]

Hello,

I know this is possible as I've seen it before but can't remember how to do it!!

How do you see a year by year comparison on a bar chart...I've seen it before where the previous year shadows behind the current data.

[deepakk]

Hi,

Since you want a year comparison with bar chart the you can simply add the year as dimesion.

or

you can create two expression one for current year like below

Sum({<Year={$(=Max(Year))}>} Sales )

and for previous year

Sum({<Year={$(=Max(Year)-1)}>} Sales )

I hope this helps.

[samvile18]

I've actually got the dimensions working properly...I'm just trying to add the ghosting function, I swear it's just a button you can click!

[#4 · Accepted solution]

Hi Sam,

Is the "ghosting function" you are looking for a set reference, i.e. on the front-end object, right-click, choose set reference and then make another selection. You will have the bars with selction showing in full colour and the set reference bars in the background with a slightly transparent colour.

Set reference only works when a cyclical dimension is not involved in the chart. Don't know if they have changed that in v10.

[samvile18]

Thats exactly what I'm after...the dimension is cyclical too...DAMN IT!

Thanks for the reply

[#6]

Have had clients that needed the set reference. Only workaround is creating N-times the chart object to allow for set ref on all chart-dimension combos. Don't know of a way around that one.

If on v10, and depending on if the amount of dims included in the cycle, would be good to use a container object. It should work like that. Sorry can't help more.