1 of 1 people found this helpful
Is it possible to alleviate this issue in the ETL process? Tableau is primarily a visualization tool and is not designed to clean data.
In some case we do this, but it's not possible at all.
The objectif of Tableau is to use operationnal Data and evict to tranform data with an ETL.
ETL are expenssive so we use materialized view before tableau extraction.
I don't really want transform the data and just want a way to calculate with a analytic function partitionned by.
But if you know a way in SQL to transform my DATA and resolve this problem, i'm interresting !
Is there not a SUM(FIRST(salary)) or SUM(MAX(salary)) possibilty.
SUM(FIRST(salary)) : FIRST can't be use in this context
SUM(MAX(salary)) : You can't use two agregation function
window_SUM(MAX(salary)) : not take a good result
window_SUM(FIRST(salary)) : FIRST can't be use in this context
IF INDEX() = 1 THEN [Salary] END
with Compute Using = [id_data]