Data Studio - Custom Dimension - MySQL
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?