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"
      )
  )
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Convert your data to an Excel data table Insert > Table (not required, but it makes it easier for data maintenance and updating long-term).
With your data table selected, insert a pivot table Insert > Pivot Table.
Setup your pivot table:
Rows = SentDate
Columns = FromNumber
Values = Count of FromNumber (may default to Sum, just change thru Value Field Settings dialog).
Insert your chart Insert > Charts > 2d Column Chart. By default, this will create a pivot chart, not a regular chart.
Format to taste.