Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
Please see the attached
Maybe using a set Expression
Max( {<Year = {">=2015<=2020"}>} EndDate) - Min({<Year = {">=2015<=2020"}>} EndDate)
Thanks for Quick response..
I want to show 2012 to 2016 years only..
PFA,
Please see the attached
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?
ThanX Kush...
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?????
HI Kush,
How to set reference line..??
Anyone face reference line issue.. Please help me
where you want the reference line?
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)