Data Studio
2.4K members online now
2.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Counting number of transaction IDs

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

 

I am guessing this is fairly straightforward. I want to create a new calculated field from Number of #Transaction IDs to be used as a Scorecard. I can't use Ecommerce > Transactions, because I'm dealing with a duplicate TransactionIDs-issue. 

 

Until that is solved, I want to show the correct number of transactions, which I will get from counting transaction IDs in GA. I haven't really succeeded with creating the calulated field myself. Any ideas?

Counting number of transaction IDs

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

I think you can do a DISTINCT COUNT on that field. It should remove the duplicate transaction IDs.