Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a line chart with date (MM/DD/YY) as x-axis dimension.
we have data for current 12 months, it shows all 12 months in the chart, but i want to show only 6 months from that as a label in x-axis but it should show 12 months data in the chart (alternate Month dates should be shown in the chart).
How we can achieve it?
here is the trick.
go to your dimensions and click on + sign..
click on text color..
there you can define condition like this:
=if(month='jan' or month='march',red(),White())
HTH
sushil