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
#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.