I want to add another column to my data so that I could actually use it. I added a calculated field, but now I cannot select it in my app. Then I reloaded my same data from Excel (but this time I used script and appended the column that I need manually). But now I have 2 data tables! I don't want to rewrite my app based on the fields of the new table.
For instance, I may want a new field where values would be concatenated from 2 other fields. I can create that by using 'calculated field' functionality. But then I cannot the use this new field as dimension in my graphs...
There must be some easy way to add a column (so that I could use it in my app) to my old table, which I don't yet know... 😕
For instance, I may want a new field where values would be concatenated from 2 other fields. I can create that by using 'calculated field' functionality. But then I cannot the use this new field as dimension in my graphs...
(Updated the original question with this example.)
