Calculated field on dataset vs in Analysis

Hi, I noticed I can create a calculated field in the dataset directly and also on the analysis that uses that data set. Any best practices on how to decide where to create the calculated field?

Thank you.

Hi,

both will work fine. but any change in calculation field in data set will take some additional steps like

you will edit the dataset and change in code.
refresh the data set if the data is big it will take some time for rows ingestions.
After that you will test it on analysis. if you calculation not working as you excepted or some change in code.

You will repeat the step up again.

So change in analysis will be quick in test.

Rest up to you what you choose :slight_smile:

regard,
Naveed Ali

Hi, couple practice tips:

  1. If you want to use the calculated field in multiple Analyses or share dataset with other authors, add it in dataset.
  2. If you want to keep the calculated field local to a Analyses then add in the dashboard.