x axis values need to change based on filter values

[#1]

Hi i have scenario

END date  2013

Start date   2019

based on the selection of above,x axis values are change start date is starting and end date is ending.

How to achieve this ?

Please do the needful

Thanks

Thiru

[swuehl]

Not really sure if I understand your setting, but you can set static min / max for a continuous x-axis (e.g. in a line chart),

and these static values can actually be expressions that evaluate your selections of above dates.

[ramasaisaksoft]

Hi Thiru,

Try like below

vmindate=min(Book_date);

vmaxdate=max(Book_date);

Dim: =if(BooK_Date>=vmindate and BooK_Date<=vmaxdate ,Book_Date)

Expression:Count(Product)

means your dim will always check min & max dates

if this is not helped to you please post your dummy data and expected output chart.

[#4]

Hi

I got this using input  box and i have added predefined values  2013 to 2015 in startdate

and 2013 to 1935 in enddate,

because end user want a drop down for years

This is working but it is static, is there any dynamic solution for this.

Thiru