My PunBB-Hosting forum

Unfortunately no one can be told what PunBB is - you have to see it for yourself.

You are not logged in.

Adverts

Adverts

#1 2017-09-22 08:09:27

JoeClark
Member
Registered: 2017-09-11
Posts: 35

Use IF Statement to Replace Number with String?

Hi,
    I have a dataset which shows % change quarter over quarter, and then a filter which only shows values that are not null. But I want to replace the % value with a string under two conditions: If the value is new (i.e., no record of it in the prior period, but record of it in the current period), I want to show the value in my visualization as "NEW" If the value is -100% (i.e., record of it in the prior period, but no record of it in the current period), I want to show the value as "MISSING".



I didn't find the right solution from the Internet.


References: https://community.tableau.com/thread/247770



3d animated video

Offline

 

2017-09-22 08:09:27

AdBot
Advertisements

Adverts

Board footer

Powered by FluxBB
Hosted by PunBB-Hosting