Vælg en organisation
How To Calculate RUNNING_SUM in Tableau Prep
Udgivelsesdato: Apr 13, 2024
Opgave
Source data:
Output:
Trin
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.
Vidensartikelnummer
001470541
Løste denne artikel dit problem?
Giv os besked, så vi kan forbedre os!
