Hi Team,
I want to use a ‘Chart Type: Table’ where all the columns comes from one collection, which I managed to create it using drag/drop in Classic UI editor.
However, need to add few more columns which are computed/calculated from data from other collection.
My question is,
- Do I need to agg. pipeline query in query tab fpor tjhe whole tab, OR, can I write a agg query for just these computed columns and somehow add them to the table ?
Hi @Praneeth_Gedela -
You can use the Calculated Fields feature to add new fields computed based on data already in the current context. However you can’t directly bring in data from an external collection using a calculated field.
Instead you should first create a Lookup Field that brings in the external data, then you can create a calculated field that leverages data from the lookup field.
You don’t need to specify either in the query bar, in fact you can’t do $lookup in the query bar.
HTH
Tom