Forum Discussion

diegolima's avatar
diegolima
Helper III
6 years ago
Solved

How to create a chart for date count and values sum

Hello, I needed to create a chart for the error control, but I don't know how to do it, this control needs to analyze the days of the month and select the ones that have more errors, and then calcula...
  • Greg_Deckler's avatar
    6 years ago

    Should be:

     

    Table =
      ADDCOLUMNS(
        SUMMARIZE(
          'Table',
          [DEVICE]
          "DATE COUNT",COUNTROWS('Table')
          "TOTAL ERROR",SUM('Table'[ERROR])
        ),
        "CATEGORY OF ERROR",
          SWITCH(TRUE(),
            [DATE COUNT] > 3 && [TOTAL ERROR] > 30 && [TOTAL ERROR] < 100,"YELLOW",
            [DATE COUNT] > 3 && [TOTAL ERROR] > 100,"RED",
            "GREEN"
          )
      )