cancel
Showing results for 
Search instead for 
Did you mean: 

How can I group together a month and get the sum of the spend for each month?

Highlighted
Image Sensor
I have multiple dates for 2 months, Aug and Sept.  I want to the sum of spend for each month as a whole.
Labels (1)
0 Kudos
1 Reply
Highlighted
Linear Actuator
@vlruch67 You can use a computed column with the month function to get the month from the date column like below:
month(@date_column@)

Additionally, if you're looking at data across different years, you could do a concatenate function to get the month and year like below:
concatenate(year(@date_column@), month(@date_column@))
Once you have this, the next step to perform is a "Shape" operation, and specifically "Group By". 

Here's a link to the help documentation for Group By shaping operation: https://paxata.atlassian.net/wiki/spaces/PaxDocs/pages/539787368/Data+Shaping+Tools+explained#DataSh...

0 Kudos