Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Apr 30, 2021, 8:18 AM

Filtering the View Without Filtering Underlying Data

Filtering the View Without Filtering Underlying DataHello,

In the above image, I have added a lookup calculation to limit the number of values on the x-axis.

 

Formula for Lookup : lookup(min(([Weeks out ])),0)

{Weeks out} is the x axis

 

Currently the range selected is -36 to 0.

There are values present for >0 but because of the lookup, it doesn't show up.

I want to show the total running sum on the 0th axis(this should include all the values available after 0)

 

adding tabular format for better understanding

total_0 

please see https://community.tableau.com/s/forum-guidelines regarding the use of mentions

I have removed the list that you had in the post

Jim

2 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    May 4, 2021, 6:11 AM

    Thanks very much Jim for the help.

    I have solved this with different logic, please check:

    set all weeks >0 to 0, moving everything >0 to occur in week0 effectively

     

    Hope this will be of some help to someone.

Write an answer...
0/9000