I created a topic with two different data sets.
in those data sets, I have a column like txn_id from dataset1 and inst_id from dateset2
Now I am trying to ask questions like “number of transactions done in Jan 2024”
in this case, it should take count from both datasets count(txn_id) + count (inst_id).
For this, I am trying to create a calculated field. But It’s not accepting to create on both datasets at time (It’s asked to select a dataset)
Please help to create calculated fields on 2 data sets in a single topic
Hi @jayakumarim,
When working with 2 datasets, you can not build a calculated field using both if they are separate. The same goes when trying to build a visual, you can only utilize one dataset at a given time.
In terms of a work around, you could potentially join the datasets if there are like fields in each dataset (same field in each dataset).
If not, you may have to manipulate your dataset to manually combine them or add the ‘txn_id’ field over to dataset 2 (or the opposite), so that you have both fields available on the same dataset.
Let me know if you have any additional questions!
1 Like
Hi @jayakumarim,
It’s been awhile since we last heard from you; checking in to see if you had any additional questions?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Thank you for the clarification @Brett
2 Likes