cancel
Showing results for 
Search instead for 
Did you mean: 

Graph x axis

former_member245931
Participant
0 Kudos

Hi,

Is it possible to restrict x axis values in a graph.

For example

Month   Revenue

201201    2000

201202    4000

201203    6000

201204    6500

201205    7000

201206    7500

201207    8000

201208    8500

201209    9000

How to show only 6 months data in the graph, where as the report has all months data

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You can apply filter on Graph block to show graph only for 6 month.

Create a variable-

Last 6 Month= If [Month]> Max([Month]) In Block -6 Then 1 Else 2

Apply filter on Graph

Last 6 Month=1

~Anuj

former_member245931
Participant
0 Kudos

This is helpful..

But for me the same graph changes to regional graph on x axis..

If i apply a filter on block i am not able to see the other one.

Is it possible with out applying filter at report block

former_member190895
Active Participant
0 Kudos

You can also filter at report level as well. Use In Report instead In Block

Former Member
0 Kudos

Hi,

You can use Input Controls to achieve this.

Regards,
Veer