Not exactly sure what the query in your yaml file is supposed to return since it seems to be different than the one you have in the first screenshot. However, here's a couple of considerations:
When you use ingest: metric in the yaml definition, you will be ingesting a metric timeseries for each of your metric key you specify. As such, you need to make sure that whatever columns you specify there return numbers and not strings (those would be better used as dimension values).
In your query you are defining nombre_canal, codigo_respuesta and nombre_fantasia as dimensions. I would guess that those don't really correspond to the values you want to have on a timeseries, but rather to dimensions.
Again, I'm guessing a bit here, but if you are trying to get cantidad per nombre_canal, codigo_respuesta, nombre_fantasia and stat_name then it makes more sense to have cantidad as your only metric and all the other ones as dimensions (also, make sure that both the dimensions and the metrics you specify show as columns in the query. Right now, you seem to be missing stat_name from your query).
Be aware though, that if you have a very high number of possible dimension values this approach can lead to a very high DDU consumption. If that's the case, then maybe it makes sense to ingest these records as logs instead and then use some DQL on a dashboard/notebook to do aggregations and analysis?
To ingest logs from an extension you simply have to specify ingest: logs instead of ingest: metrics and then define the attributes instead of metrics and dimensions. If you download the official Postgres extension or Oracle extension from the Dynatrace Hub and ctrl+f the extension.yaml file for ingest: logs you can find an example of how it's done (as of the time of writing this post).
MaciejNeumann
