Where C* databases seems to fall down are point updates and in this case, requirement to implement your own aggregations.
For these workloads you are much better off (unless you are already running C* somewhere and are super familiar with it) with something like Clickhouse or if you need good slice and dice then Druid or Pinot.
