10 Replies Latest reply on Mar 4, 2015 7:27 AM by Toby Erkson

# what is this operator in tableau "_" please tell me any example  on this operator using calculation

what is this operator in tableau "_" please tell me any example  on this operator using calculation

• ###### 1. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

Hi We can use this and do with some strings.

str([Bt Date])+ "_" + str([Country Id])

it will show as 03/03/2015_100

thanks

sankar

1 of 1 people found this helpful
• ###### 2. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

Hi Arun

Where do you see it?

I only know of these in Tableau...?!

Operators

The only place I see underscores (''_'') are function names such as WINDOW_SUM, RUNNING_COUNT etc.

Cheers

Mark

• ###### 3. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

Hi shankar,

_

where we use this operator and for what purpose we use this operator "_"

• ###### 4. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

Hi Arun,

We can use this when we do some concatenation.

[customers first name])+ "_" + [Customer last Name]

it will show as Sankar_Rajan

Thanks

sankar

• ###### 5. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

means it will add '_' thats it

• ###### 6. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

s

• ###### 7. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

ok shankar i got your point,please can u explain this caluculation i.e what output it will display..?

STR(DATEPART('month',[Transaction Date]))+"-"+STR(YEAR([Transaction Date]))

• ###### 8. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

Hi Arun

The output will be something like this (as a string/ text):

March-15

It will obviously depend on the data in your transaction date field.

Cheers

Mark

• ###### 9. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

when you add this calc into row, then

o/p

1-2010

1-2011

1-2012

2-2010

2-2011

2-2012

Like

1 of 1 people found this helpful
• ###### 10. Re: what is this operator in tableau "_" please tell me any example  on this operator using calculation

arun kotla wrote:

what is this operator in tableau "_" please tell me any example  on this operator using calculation

The underscore is not an operator.