3 Replies Latest reply on Sep 7, 2017 3:36 PM by Hari Ankem

    Question regarding LOD Calculation and calculated fields

    Aishwarya Sawant

      I am looking for help to determine the count of records in a partition in tableau. For instance

       

      OrderID

      OrderLine

      Payment

      1

      1

      50

      1

      2

      100

      2

      1

      500

      3

      1

      20

      3

      2

      60

      3

      3

      80

      4

      1

      80

      4

      2

      70

       

      Therefore, I am looking for an output of Count field which determines the number of orderliness.

       

      OrderID

      OrderLine

      Payment

      Count

      1

      1

      50

      2

      1

      2

      100

      2

      2

      1

      500

      1

      3

      1

      20

      3

      3

      2

      60

      3

      3

      3

      80

      3

      4

      1

      80

      2

      4

      2

      70

      2

      Further, I needed “count of orderline “to be dynamic. For instance, if I filter for all the orders with an order line <> 2, the count need to be updated respectively.

      The text highlighted in yellow are the rows that have been filtered out.

      OrderID

      OrderLine

      Payment

      Count

      1

      1

      50

      1

      1

      2

      100

      2

      2

      1

      500

      1

      3

      1

      20

      2

      3

      2

      60

      3

      3

      3

      80

      2

      4

      1

      80

      1

      4

      2

      70

      2