Forum Discussion

CamillaDiPassio's avatar
CamillaDiPassio
Frequent Visitor
3 years ago
Solved

Group multiple columns

Hello everyone,  I have a problem with a set of data. I have three different columns and I would like to know for each Code per month the sum of the Alert.  For example: for the code 9765 I have 3 ...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    CamillaDiPassio 

    1. Create a Month column: Month = FORMAT([Date],"mmmm")
    2. Create a MonthSort column: MonthSort = MONTH([Date])
    3. Set Sort By for Month to be MonthSort
    4. Put Code in a Matrix visual (rows)
    5. Put Month in the Matrix visual (column)
    6. Put Alert in the Matrix visual (values, sum aggregation)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

CamillaDiPassio 

  1. Create a Month column: Month = FORMAT([Date],"mmmm")
  2. Create a MonthSort column: MonthSort = MONTH([Date])
  3. Set Sort By for Month to be MonthSort
  4. Put Code in a Matrix visual (rows)
  5. Put Month in the Matrix visual (column)
  6. Put Alert in the Matrix visual (values, sum aggregation)