Allowing user to select the month range (Dimension) to view the data

[Anonymous]

Hi all ,

I have a bar chart which displays the sum(amount) for all the months.

Dimension = month

expression  = sum(amount)

now the user wants to select the months flexibly and not restrained to 12 months periods and can be set within a flexible time frame.

Kindly suggest on how this can be acheived.

Thanks

[sunny_talwar · Accepted solution]

May be add MonthYear as a dimension instead of just Month?

[Anonymous]

Hi Sunny ,

Yes i have done that , but i want to allow the user to select the number of Month-year he wants to view on the chart.

Any ideas on that ?

Thanks

[sunny_talwar]

I am not sure I understand... why can't the user select the month-years they want to? What is going wrong when they try to select there preferences?

[sudhirpkuwar]

Hi,

You can create a variable and make it use in the dimension limit tab

[rsdhavle]

can you give some more details as Sunny asked? Cause user can make selections by list box which will reflect on chart so what scenario are you trying to achieve exactly?

[Anonymous]

Hi Sunny ,

I had implemented this , thanks for the response.

it is serving my purpose.

Thanks

[sunny_talwar]

Awesome