Hey! The updated power calculation has been a gre...
# ask-questions
h
Hey! The updated power calculation has been a great tool since it has sped up the process a lot for us. I've noticed however that after I updated my fact tables that it doesn't seem to be able to pull metrics from past experiments anymore. I can see that metrics from fact tables that I didn't update still works, so i'm not sure if it's some caching of my old queries in the background causing this error? The metrics works in the experiments as they should, so no issues there.
f
@helpful-application-7107 do you have any thoughts?
h
When you select past experiments, only metrics that are still in your app and that are in those old experiments are available for selection. When you say you "updated my fact tables" did you create new versions of metrics and delete the old ones?
h
@helpful-application-7107 I never deleted the metrics, so it was the same metrics - as in going to the metrics overview - but the underlying query (from fact tables) is different. I did however think that I would need to recreate them, but I guess that's the beauty of fact tables hehe. The primary thing I did in the fact tables was to change the identificator and create a join table instead. And actually writing this message I realize that it might be there the issue is? That the power calculator perhaps doesn't consider join tables, meaning that the metrics need to have the same identificator as the experiment assignment table. Just a thought