4 Replies Latest reply on Aug 25, 2018 10:11 AM by Srikanth Goli

    Value Based on Filter Selection

    Srikanth Goli

      Hi Everone,


      I am having some trouble trying to accomplish some basic calculation with Tableau so thought of leveraging the team's expertise.


      So I am trying to calculate avg based on the number of days selected by users in date filter. If you see the below image, user selected 6 days so I want a new column which divides the Furniture profit 74.2/6 = 12.3, 580/6, and so on. It should not consider whether there is data present in that aggregation level or not.


      My scenario is a bit more complicated but I drilled down to this simple scenario to get started since I cannot share confidential data outside.


      Tableau Desktop Version: 10.5 and workbook attached.


      Thank you in advance!