Valitse organisaatio
How To Calculate RUNNING_SUM in Tableau Prep
Julkaisupäivä: Apr 13, 2024
Tehtävä
Source data:
Output:
Vaiheet
2. Add a Clean Step [Clean 1]
3. Join [Sheet 1] and [Clean 1] with clauses below:
[Clean 1].[Order Date] >= [Sheet 1].[Order Date]
[Clean 1].[Category] = [Sheet 1].[Category]
4. Rename [Sheet 1].[Sales] to [RUNNING_SUM(Sales)]
5. Add Aggregate [Aggregate 1] step as bellow:
Grouped Fields: [Clean 1].[Order Date] & [Clean 1].[Category]
Aggregated Fields: SUM ( [RUNNING_SUM(Sales)] )
6. Join [Aggregate 1] and [Clean 1] with clauses below:
[Clean 1].[Order Date] = [Aggregate1].[Order Date]
[Clean 1].[Category] = [Aggregate 1].[Category]
7. Remove the fields that are not needed in the Output.
Please refer to the attached sample flow file for details.
Knowledge-artikkelin numero
001470541
Ratkaisiko tämä artikkeli ongelmasi?
Anna palautetta, jotta voimme kehittyä!
