i was wondering if it would be possible to add a “calculated field” into the Pivot visualization, like you have in MS Excel and Google Spreadsheets? Also would it be possible to add additional “value” fields, e.g. sum of X AND sum of Y?
Basically i want to calculate the ratio between 2 values and display them all together (e.g. impressions | answers | conversion rate (answers/impressions), which isn’t really doable in the SQL because of aggregation issues (why i use a pivot table in the first place).
Is any of this possibly as of now?