3 Replies Latest reply on Mar 15, 2018 12:52 PM by Deepak Rai

    Calculations

    Rose K

      I'm trying to write a calculated field for the output but I'm not sure how do I how to include date field to get 12 months data.

       

      My business logic is

       

      Sales(this is a numeric value)/12 months(date field)no of members in group.

       

      Sales: Represents the total sales

      Date field : Need to get data for only 12 months(most recent) - I have already created a rolling 12 month filter which is set to true but in this calculated field.

      Number of members in a group - We have 20 different groups so, we should get the count of members for one each group.

       

      ANy suggestions how this can be rephrased to a calculated field in Tableau.

      Thank You

      Rose!!!