Forum Discussion

diegolima's avatar
diegolima
Icon for Helper III rankHelper 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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    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"
      )
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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"
      )
  )