Jeffrey Shaffer @DataPlusScience

5 years ago

Tableau Tip of the Day: CASE Statement Maker Calc. Need to populate a long list into a CASE. Here's a Calc. //CASE [Sub-Category] str("WHEN '" + min([Sub-Category]) + "' THEN " + str(index())) Drop calc on canvas, copy from data window and paste into new calc. #TableauTip

8 15 133 0 29

Download Gif

Andy Kriebel @VizWizBI

5 years ago

@HighVizAbility Brilliant!

0 0 1 0 0

Irene Diomi @VizWithIrene

a year ago

@DataPlusScience @imani__r Pretty cool

0 0 2 79 0

Jennifer Dawes @jreevers5

a year ago

@DataPlusScience

0 0 1 43 0

Download Gif

Roy Wang @kickoflegend

5 years ago

@HighVizAbility Ooh nice. I’ll have to remember that!

0 0 1 0 0

Kamal @Kamalde00211896

5 years ago

@HighVizAbility This is amazing Jeffrey!

0 0 1 0 0

WordSwords @nathanwatkins

5 years ago

@HighVizAbility Not bad, sir. Not bad at all!

0 0 1 0 0

Roger de la Rosa @rdelar01

5 years ago

@HighVizAbility Thank You!

0 0 1 0 0

Download Gif

Lynne Cotter @lynnemargalit

5 years ago

@HighVizAbility Would this slow performance because it's calling a pill instead of just the values?

1 0 0 0 0