Forum Discussion
diegolima
6 years agoHelper III
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...
- 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" ) )
diegolima
6 years agoHelper III
Thank you all so much for your help
- Greg_Deckler6 years agoCommunity ChampionMy pleasure! 🙂