3 Replies Latest reply on Mar 16, 2019 11:40 AM by Jonathan Fronhoffs

    Sorting long form data & dashboards with mulyiple filters

    Jonathan Fronhoffs



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

      I have a file (attached) with:


      - Make



      - 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!