In Tableau how can I create a calculated field that categorizes data based on data across rows?

Achyutha Mohan

I have a tableau table that looks like this :

Initial_Dataset

I want the following output:

Desired_Output

robcrock

If don't mind only having the 'Part' pill on the view, like this...

Example of where to place your pills

Then the calculation below will meet your needs. Removing 'Types' from the view allows the data to aggregate in a way we can use to come up with the categories you want.

Size Category Calculation Image

However, if you would like to add more dimensions to the view we need to control the level of detail in our calculation. Thankfully, we can do this with LOD functions.

Level of detail calculation

This calculation "fixes" out Level of Detail at the Part LOD. You can see I have added 'Another Dim' the view and it still works.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

How can I create a new binary variable that categorizes people based on if they EVER had a certain response in the dataset?

How can I create a new data frame with several rows for each observation based on string column?

How can I create a new wide data frame with rows based on all combos of values in two columns?

In tableau, I want to create a calculated field which is based on a filter and outputs an answer also based on a filter

How can I swap selected data in 2 rows based on criteria

R: How can I add rows based on values of a data frame?

Group and count data based on a calculated field in mysql?

How can I create rows of data using jquery append()?

How can i create with fastest method 250.000.000.000 rows data

How can I create a function in R that calculations across rows?

How can I create a new data frame based on the existing columns?

Create calculated field based on previous rows Oracle SQL

Tableau Calculated Field - across multiple measures

How do I copy data across rows depending on the year?

How can I get data based on id and pass data text field for editting

How can I reference a calculated field in a subquery?

Create calculated field based on other calculated fields

how can I create a new data frame using exact rows from the old data frame in R Studio?

How to filter data based on two conditions in rows in Tableau

how to merge data across data.frame rows based on identical column values

How can I select all rows based on the AVG calculated in another column?

In D3, how can I create multiple elements for each data element based on value in data?

How do I create semi-duplicate rows in pandas based on text data?

How to create a historical dataframe with calculated data?

Add calculated Field between Pivot 'Columns' based on 'Values' data

How can I drop rows based on given conditions in pandas and how to force converting data types?

How can i check if the value for "_id" field exists and how to read, write, update and delete data based on it

How can I share variable data across different files in React

How can I share/persist data/status across webdriverio specs?