4 Replies Latest reply on Nov 30, 2016 2:40 AM by wiem bekir

Incremental field

wiem bekir Nov 30, 2016 1:39 AM

Hello

I need to add a text field that increment like that :

KPI Key

KNWA0501

KNWA0502

KNWA0503

KNWA0504

KNWA0505

KNWA0506

KNWA0507

How to do it please ?

Thanks

1. Re: Incremental field

Ashish Chaudhari Nov 30, 2016 1:54 AM (in response to wiem bekir)

Hi Wiem,

Can you explain the scenario little bit? That would help to formulate the solution. This is obviously can be done using index or Rank functions concatenating with the text that you want.

As per my suggestion, Actual context understanding is needed before we go ahead with any formula.

-Ashish
Like Show 0 Likes(0)

Actions
2. Re: Incremental field

wiem bekir Nov 30, 2016 2:14 AM (in response to Ashish Chaudhari)

Hello Ashish

I had 5 KPI s as bellow :

I need to add a new colonne with KPI NUMBERS. That's it

Thanks a lot
Like Show 0 Likes(0)

Actions
3. Re: Incremental field

Irfan Ahamad Nov 30, 2016 2:31 AM (in response to wiem bekir)
Hi Wiem,

Please follow the below steps-
1. Create a calculated filed Index-
500+INDEX()

2. Convert this discrete

3. Put to row self-

4. Go to the format-
In Prefix put KNWA-

Go thru the attachment.

IndexPrefix.twbx 1.2 MB
Like Show 0 Likes(0)

Actions
4. Re: Incremental field

wiem bekir Nov 30, 2016 2:40 AM (in response to Irfan Ahamad)

Thanks a lot I would like to add a text field concatenated with the index "test" + INDEX()
the result would be like :
test1
test2
test3
Like Show 0 Likes(0)

Actions

Tableau Community