Back

Explore Courses Blog Tutorials Interview Questions

Tableau:Create a calculated field using Case statement and case statement uses a logical calculation

0 votes
2 views
in BI by (17.6k points)

I have a question regarding tableau calculated field.

I am using Sample Super Store data. Below is my questions

I want to Categorize Sales into 'Low Sales','High Sales' and 'Super Sales' based on below

using Case Statements

SUM(Sales)>500000 then categorize as 'Less Sales' (Sales) between 500000 and 1000000 then 'High Sales' Else SUM(Sales)>1000000 then 'Super Sales'

After categorising I need to find out the count of [Order] under Super Sales '

Please log in or register to answer this question.

Related questions

0 votes
1 answer
Tableau Calculated Field using FIXED
asked Jul 26, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
Tableau Calculated Field with Max and Index
asked Nov 23, 2020 in BI by Vamsee Krishna (22.5k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...