Showing today on a chart

[Dayna]

Hello All,

This might sound silly, but I want to make it obvious on a bar or line chart where today is. I have multiple dimensions and expressions, and one of the dimensions will be date or week/year.

I was thinking of doing an IF statement on the colour to change for today(), but then the legend gets screwed up..

Any ideas? I just want to make it obvious to the users where the current date is on the chart!

Kind Regards,
Dayna

[deepakk]

hi Dayna,

PFA

[Dayna]

Hello Deepak,

Thank you for your quick reply, unfortunately if you have more than one expression the legend doesn't work...

Kind Regards,

Dayna

[deepakk]

hi,

Then in each expression you have to do it.

[Dayna]

Hello Deepak,

That isn't the solution I need, as I have already done it (please see my original post).

If one of my dimensions is Part, then I want the legend to show a different colour for each part (20+), but using the colour in the chart will break this which is no good. I need the users to be able to view which line belongs to each site/part.

I already did your original post but changed the colour to black for each expression, but this won't work.

Regards,
Dayna

[deepakk]

HI Dayna,

Can you attach a sample file, I will like to see it.

[Dayna]

Hello Deepak,

Please find attached, this isn't my data but will present my problem.

Dayna

[deepakk]

HI Dayna,

If legend is a problem. It would be better to disable it and use a text object to display legend

like create green color text box and write a name as FLN. Similarly for Others. IN this way you will be able to show an indication to user on Today date and also will be able to show the legends.

[Dayna]

This is only a small example, in my actual application I would have 100+ products shown, so it wouldn't be feasible.

Is there any other route I could go down, instead of changing the colour of the bar maybe add another bar or blob that shows todays date?

[deepakk]

hi,

How about changing only the text color instead of Background.?