Restrict Years

[Nagaraju_KCS]

Hi All,

I want to restrict years front end (UI)..

i have many years like 2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024

In my chart i have to show only 2015,2016,2017,2018,2019,2020

I have Gantt Chart... this is my expression   Max(EndDate) - Min(StartDate)

Thanks in Advance....

[swuehl]

Maybe using a set Expression

Max( {<Year = {">=2015<=2020"}>} EndDate) - Min({<Year = {">=2015<=2020"}>} EndDate)

[Nagaraju_KCS]

Thanks for Quick response..

I want to  show 2012 to 2016 years only..

PFA,

[Kushal_Chawda · Accepted solution]

Please see the attached

[#5]

Hi Qv_Testing

Do you mean to only show cases started in those years on your Gantt chart? If so, one option would be to add a calculated dimension to your chart, to replace years outside your range with nulls, then suppress null. (See the attached, also with a list box showing Year(StartDate) ).

I believe you'd get better performance if you can calculate 'Year(StartDate) AS StartYear' as part of your load script, so you don't have to keep calculating that on the fly.

Does that answer your query?

[Nagaraju_KCS]

ThanX Kush...

[Nagaraju_KCS]

Hi All,

Thanks EveryOne..

My problem is reference line it should be after 2015 year

My scale also it should be unique years, that's why i have mentioned static step 365 days..

Please anyone can help me?????

[Nagaraju_KCS]

HI Kush,

How to set reference line..??

Anyone face reference line issue.. Please help me

[Kushal_Chawda]

where you want the reference line?

[Nagaraju_KCS]

in chart..

i used in Presentation tab--> reference line

exp  today()

but in my chart reference line it showing before 2015 year... i want to show after 2015 (it should be after 2015)