Data Studio
4.6K members online now
4.6K members online now
Ask questions about Data Studio
Guide Me

Data Studio - Custom Dimension - MySQL

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I managed to connect Data Studio to my MySQL database, but my metrics aren't good for reports, so I need to create some custom metrics, and I have some doubts:


1 - I'm trying to create a metric that counts some ids, but I try to enter the formula COUNT(id) and it doesn't work. What do I do?


2 - In the filters, it doesn't appears all the metrics that I have in my table database (but they appear in the metrics section). Why is that?


3 - When I try to create graphics, I try to create using different ids, like id_user and id_product. For one of them the graphic works, but it doesn't for the other. Why is that? Do I need to adapt my database to another format before using it?