Skip to main content

Hi I have a data, Twbx attached - I want to calculate the date when 'Guarantee' is achieved.

For Eg - for uni Abc we are reaching the guaranteed interactions on 4 Jan 2021 , I would like to display the date 4 Jan 2021 in a separate column "Target Achieved"

3 respostas
  1. 2 de jun. de 2022, 19:09

    @nitin Pal Singh​ Because we're using a RUNNING_SUM(), we have to continue to use table calculations to return the date the target is achieved. The kicker is that in order for the RUNNING_SUM() to be computed correctly, DAY(Date) MUST be in the view. You can build the view to make it look like the extra dimension isn't there, see Computing a Table Calculation by a Dimension Not Present in the View

     

    Please @ me in replies otherwise I won't receive a notification. Hope this helps :)What do you think of the new Community Forums? Let us know at https://community.tableau.com/s/community-feedback (Be sure to tag your ideas as 'community)