2 Replies Latest reply on Jul 6, 2018 3:48 PM by Jonathan Fronhoffs

    Sorting long form data & dashboards with mulyiple filters

    Jonathan Fronhoffs

      Hi,

       

      I'm trying to create a dashboard to compare performance of solar panels.

      I have a file (attached) with:

       

      - Make

      -Model

      -Type

      - Output per year for 4 different climate zones.

       

      What I'm trying to get is a dashboard where you could filter based on

      - Make

      - Type

      - Climate zone

      - Narrow down to 3 solar panel models.

      I thought about using drop downs

       

      I think I can work out the climate zones by showing 4 graphs, one for each climated zone, but i'm at a loss as to how to use the pivot function for the data.

       

      Any help or links are very welcome!

       

      Thanks,

       

      Jonathan