Is it possible to select the years shown in the columns via selection in a Gantt Chart?
I have two date cube dimensioned by task that I need to visualise as a Gantt Chart.
Now, I want to not show all the years but restrict it to only a few, however when I select years in the time dimension it does not restrict the shown years in the Gantt Chart.
Is there a way to select the years I want to show?
Answers
-
The time dimension of the gantt chart is dynamic and will always display the time range according to the tasks that are displayed. To my knowledge it is not possible to cut off tasks by limiting a time range in the selection.
Depending on your task model something that could work is to set up a help cube which maps tasks to the desired time range (e.g. start date, end date or duration) and set a filter in the data view to only display tasks which fulfill the condition.
Keep in mind that this will not cut off tasks with a longer duration than the selected time range but you can limit the display and corresponding time dimension of the gantt chart.
1 -
In the Layout editor, under the Object properties panel, a few dropdown menus allow you to define which Blocks will be used for displaying data in the Gantt chart.
They are the following:
- Start date (required). Defines the Date Cube containing the start dates of activities
- End date (required). Defines the Date Cube containing the end dates of activities
In the case where the configuration of the Gantt chart object results in additional columns in the left area of the chart, the following icons will be available:
- Timeline scale. Allows you to change the time period displayed in the activity bars area
0
Categories
- All Categories
- 1.9K Forums
- 1.8K Platform
- 153 Academy
- 314 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 47 How-To Guides
- 19 Board Advocacy Program
- 184 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 335 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP