Now I have a table like this
how can I change the show of X-value dimension like the following?
You need to limit your dimensions by If Condition...
Kindly let us know what is the dimension you used and how you get your dimension
i.e. if MonthYear is the dimension, what is your formula in script...
we can use Dual function or Autonumber to create an ID for it and can use in calculated dimension.
Yes the dimension is Yearmonth and it's the original field name...
How can I use the function you mentioned? Do it affect the calculated expression?
What I want is not show all of the label of the yearmonth but every 6 month.
What should I do next step?
Can I have your sample data file or sample apps?
Hi Sorry for late.
The attachment is the sample data. Please help to see.
See the attached
But in your attachment the X-Axes just show the smallest 10 value like this:
200803 200804 200805 200806 200807 200808 200809 200810 200811 200812
I think I need the show of the X-Axes every 6 month......
200803 200809 200903 200909 201003 201009 201103 201109 201203 201209
What Should I do?
Here it is
but in this way, it will only show expression result for the limited dimension
Is the value continuing?
Yes! It could work! thanks!
I think this is what you want. Please see attachment.
Thanks but I just want to change the show of the X-value not the expression....In your method while the show of the yearmonth has been changed but it related value has not been changed....
Retrieving data ...