Script Create new Fields

[#1]

Could you confirm that it is possible to create new fields in the SCRIPT, and that these fields can be referred to by their label name in a calculated dimension in a New Sheet Object (Pivot Table) ?

Thanks in advance

[marcus_sommer]

Yes that is possible but if you could you should rather use normal field as dimensions instead of calculated dimensions.

- Marcus

[#3]

thanks

I mean: it is possible to use this new Field inside an expression for a calculated dimension, as for instance an aggregation over this field?

[marcus_sommer]

Generally you could all fields use for expressions or calculated dimensions but if you can keep it so simply as possible. Some pre-aggregation within the script could save a lot of performance and effort to build and maintain the app.

- Marcus