Create a different table with calculated columns from previous table
I have a main table with 100+ columns. In order to avoid confusion, I created a new table with 7 columns from main table and added lot of calculated columns in this new table. I have charts from this new table.
Now my requirement is to create few more tables, few more charts similar to the new table and new chart but with different set of columns from the main table. The logics for calculated columns are same. Is there any way to automate this process ? maybe in iron python or something else ?
I don't know your exact data structure but it sounds like that you could maybe simplify your data set with a transformation (like unpivot) and then do the calcualtions only once. Could you share some data?