4 Replies Latest reply on May 15, 2017 11:17 AM by Bodhisattva Dasgupta

    Dynamically hide gannt bar for one value of a measure

    Bodhisattva Dasgupta

      I have data which looks like this.

       

      5-15-2017 7-38-56 PM.jpg

       

      with this, i have created a gannt which looks like this

       

      5-15-2017 7-49-48 PM.jpg

       

      but the issue here is that I do not want the first "Incoming" bar - which starts from 0 all the way up to 10k

       

      That is, i would like my chart to look like this - and as a result, my axis also gets re-adjusted to start from somewhere close to 9k

       

      5-15-2017 7-50-17 PM.jpg

       

      How do i achieve this ?

       

      Guess some Table Calculation - but unable to crack it !

       

      UPDATE : manually setting the axis wont work since my data repeats for multiple PRODUCT TYPES. Thus, I would like some Table Calculation to be able to dynamically "hide" the first bar of every PRODUCT TYPE