Skip to main content

Hi,

1st Query: Kindly tell me if we can import R files(.rds files) in Tableau. If yes then How.

 

2nd Query: Kindly suggest how to use Where function while doing custom calculation in calculated field.

like I want to write expression like:  avg(sales where state = NY)-avg(sales where state=AT)      [kindly note , in my above statement I have assumed that i have 2 fields(column)  one state and second sales]

 

Thanks in advance

Sid

3 answers
  1. Dec 3, 2013, 2:12 PM

    #1) You cannot just import RDS files into Tableau, as far as I know.  R was integrated as a series of Table Calculations inside of Tableau--more info here: Tableau 8.1 and R | Tableau Software

     

    #2)

    AVG(IF [State] = 'NY' then [Sales] END)

    -

    AVG(IF [State] = 'AT' then [Sales] END)

    //alternatively, you could create a calculated field for each State's average, and then subtract the two fields (one extra step).

     

    Hope this helps.

0/9000