3 Replies Latest reply: Sep 11, 2014 5:11 AM by Jose Federico Moreno Penzo RSS

    Gantt type chart

    Tom Jones

      Hi,

       

      I've created a Gantt-style chart using a stacked bar chart that displays pretty much what I want it to.  However, the way I've done it uses a lot of memory due to using 40+ expressions, I'm wondering if anyone has a better idea of going about things.

       

      I have several events with a start time, then each event has sub-events that each have start and end times.  I've calculated the minutes in between start and and end times, given each sub-event a rank based on its start time, then stacked the values in rank order.

       

      So for each event, the expressions run something like this:

       

      =only({$<rank={'1'}>}prep_time)

      =only({$<rank={'1'}>}session_time)

      =only({$<rank={'1'}>}close_time)

      =only({$<rank={'1'}>}down_time)

      =only({$<rank={'2'}>}prep_time)

      =only({$<rank={'2'}>}session_time)

      =only({$<rank={'2'}>}close_time)

      =only({$<rank={'2'}>}down_time)

      .

      .

      `.

      =only({$<rank={'     ..n     '}>}prep_time)

      =only({$<rank={'     ..n     '}>}session_time)

      =only({$<rank={'     ..n     '}>}close_time)

      =only({$<rank={'     ..n     '}>}down_time)

       

      for n sub-events.

       

      Currently I've got 10 sub-events, but this will probably need to increase to more.

       

      This is an image of what the chart looks like for 2 events:gantt.JPG.jpg

      Does anyone have any ideas on a different approach?

       

      Thanks

       

      Tom