Updating rollups when the input changes148
Pages:
1
![]() |
seckford private msg quote post Address this user | |
I had some problems with a 6 minute interval datastream where some inputs went to zero, which throws off the daily / weekly max / min rollups. I've tried deleting the data from the original stream, using Delete for the specific original entry, but that doesn't update the rollup. Is there any way to force a recalculation of rollups? Deleting a range of entries seems to do that. Will |
||
Post 1 IP flag post |
![]() |
MikeMills private msg quote post Address this user | |
Deleting, today, will not do a recalc of rollups. A component reconcile will trigger a recalc of rollups. For example, remove the stream rollup calendar, save the component, wait until the reconcile is complete, re-assign the rollup calendar, and save the component. Why don't we do a recalc of rollups during delete? We used to do a recalc but changed it to satisfy the use case of allowing the tail of a stream to be deleted (think of the delete profile) while preserving all of the rollups. This way, vast amounts of detailed stream data could be removed from the store, while allowing rollup statistics to remain. But, we've been reconsidering this design since you posted the delete bug. I think what we'll do is leave the design but have a "Force Rollup Recalculation" option during a manual delete from the studio. |
||
Post 2 IP flag post |
![]() |
seckford private msg quote post Address this user | |
"Force rollup recalc" sounds the best solution to me. It's not something you always want, but sometimes it's necessary. I can see that doing it automatically on tail delete would be a problem. Will |
||
Post 3 IP flag post |
![]() |
seckford private msg quote post Address this user | |
I've tried the sequence:
but the minimum value stays at its original zero, generated by the faulty input. Is there another way to force a complete recalc? (Later) Ah-HA! Dumb looks still free; editing the underlying stream alone isn't enough, you have to edit the problematic derived stream as well, and the dashboard is then updated. I'm not sure if this is a bug or a feature, but it solves my problem. |
||
Post 4 IP flag post |
![]() |
MikeMills private msg quote post Address this user | |
Rollups are now updated during deletes. | ||
Post 5 IP flag post |
Pages:
1