topic Re: Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row in App Development

Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row

stevenoga1 — Sat, 16 Nov 2024 20:22:30 GMT

I have a pivot table. The row values are server events (EVENT). The columns are the range of dates across which the server events were opened(OPEN_DATE). The measure is a count of the server events opened on each date (TCOUNT)

I want to create a Background Color expression that will cause a cell to turn red if .... the total number of events opened on that date (TCOUNT) for a given server event (EVENT) exceeds AVG(TCOUNT) + 3* STDEV(TCOUNT) .

I am pretty new with expressions so any assistance on this would be greatly appreciated.

Re: Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row

stevenoga1 — Sun, 28 Jul 2019 19:00:42 GMT

Solved it... Thanks

Re: Setting Pivot Table row cell color based on cell value exceeding Mean + 3* Stdev for the row

stevenoga1 — Sun, 28 Jul 2019 19:02:57 GMT

My Solution

=IF (RowNo() <> 0 AND ColumnNo() <> 0

AND Open_Date > MAX(ALL Open_Date)-40 /* only applies equation to the most current 40 days /*

AND SUM(Case_CNT) >= Aggr(Avg(Aggr(SUM(Case_CNT),Open_Date,Standard_Event)) + 3 * Stdev(Aggr(SUM(Case_CNT),Open_Date,Standard_Event)),Standard_Event), Red(), White())