I have pivoted my dataset to generate a table. The row and column header are auto generated based on attributes of dataset. My requirement is instead of each count, I want a percentage.
Search Query 😐 pivot Fill_Latency RootObject count(RootObject) AS "Fill Count" SPLITROW TradeDate AS TradeDate SPLITCOL DurationRangeSec SORT 100 TradeDate ROWSUMMARY 0 COLSUMMARY 0 NUMCOLS 100 SHOWOTHER 1
Date | RangeA | RangeB | RangeC |
19/02/2021 | 425 | 1195 | 1584 |
10/03/2021 | 70 | 0 | 0 |
17/03/2021 | 28002 | 35927 | 9839 |
Expectation>
Date | RangeA | RangeB | RangeC |
19/02/2021 | 13.2646692 | 37.2971286 | 49.4382022 |
10/03/2021 | 100 | 0 | 0 |
17/03/2021 | 37.9595489 | 48.7026895 | 13.3377616 |
@somesoni2 @tdhellma @Melstrathdee @martin_mueller @okrabbe