5 Replies Latest reply on Apr 17, 2019 3:26 AM by Artem Popov

    Different types of LOD aggregation in Tableau Prep

    Artem Popov

      Hello there!

       

      I've got input data looks like that:

      All dimensions are in rows (include FACT NAME), measure (Fact Value) is in last column.

      I need to aggregate data by months (weeks is not needed), but '"yellow" facts I need to sum, but from "blue" ones take an average.

      I can to it in Tableau Desktop by LOD calculations, but it would be very useful to perform it in Prep.

       

      Can you please suggest how it could be done?

       

      Thank you!