6 Replies Latest reply on Jun 4, 2017 5:13 PM by Zhouyi Zhang

    Combine/Consolidate/Merge two worksheets

    Richard Rogers

      Hi folks,

       

      I have two worksheets that are very similar, they are named [MetricsByKM] and [MetricsByRunTime].

      They both show three metrics: HeartRate, Cadence, and Speed, in three line plots.

       

      The only difference between them are the units along the X-axis. MetricsByKM shows distance in kilometres, MetricsByRunTime shows time since start.

      [MetricsByKM]:

      MetricsByKM.JPG

       

      [MetricsByRunTime]:

      MetricsByRunTime.JPG

       

      I have these worksheets in my dashboard, and they are working well.

       

      I'd like to merge these two worksheets into one that includes a radio button with two options:

      ViewBy.JPG

      Is there a way that I could place the two worksheets in the dashboard, and bring one of them to the forefront, based on the user selection?

      Or should I combine/merge the two worksheets, and somehow get a the "View By control" in the worksheet?

       

      I would really appreciate someone telling me what approach to take.

       

      Thank you,

       

      Richard Rogers