I'm going down one rabbit hole after another. I wonder if someone would offer some input. I have hourly data that I want to aggregate by Date and Count. Based on this data, I want to establish another column showing how many Standard Deviations the Count is away from the average. The average of the data below is 99.4, and the standard deviation is 17.4.

I've explored DataTables, TimeLion, and VisualBuilder. It seems that VisualBuilder allows some sort of sibling pipeline Standard Deviations... but I am at a loss as to how to get it to work for my data - though at this point I don't think it will! Any insight would be greatly appreciated.

Date | Count | SDs |
---|---|---|

2/1/2020 | 119 | 1.1 |

2/2/2020 | 105 | 0.3 |

2/3/2020 | 109 | 0.6 |

2/4/2020 | 89 | -0.6 |

2/5/2020 | 75 | -1.4 |