Date field not aggregated when I try to aggregate with two fields

I’m trying to aggregate with two fields, first with date and after with text field.

I obtain the error date field is not aggregated:

https://drive.google.com/file/d/1S5MFohZdPbmPIbl1Ued8cBTJBEfcwkdT/view?usp=sharing

How coul I solve this issue to obtain a graph similar to this?
https://drive.google.com/file/d/1vL-yjfJUlUiUjbjgGkMNA116OfA7l3Sk/view?usp=sharing

Thanks

Any ideas about this? Please, I need help :innocent:

Hi @aris_pg

  1. Post “Diagnostic Info” from Admin > Troubleshooting
  2. Explain what you’re trying to do.
  3. Include query examples (not links to external site)
  4. Include screenshots (not links to external site)

Thanks @flamber for your response. I send you the information your asking me:

  1. Diagnostic info

Blockquote
{
“browser-info”: {
“language”: “es-ES”,
“platform”: “Linux x86_64”,
“userAgent”: “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.122 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “1.8.0_232-8u232-b09-0ubuntu1~19.04.1-b09”,
“java.vendor”: “Private Build”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_232”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “25.232-b09”,
“os.name”: “Linux”,
“os.version”: “5.0.0-38-generic”,
“user.language”: “es”,
“user.timezone”: “Europe/Madrid”
},
“metabase-info”: {
“databases”: [
“h2”,
“redshift”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
},
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
}
},
“run-mode”: “prod”,
“version”: {
“tag”: “v0.34.3”,
“date”: “2020-02-25”,
“branch”: “release-0.34.x”,
“hash”: “1a83edb”
},
“settings”: {
“report-timezone”: null
}
}
}

  1. I’m trying to aggregate with two fields, first with date and after with text field (event name)

I would like to obtain a visualization similar to this one (x-axis = Data, grouping by my text field (event name)

@aris_pg
What’s the actual column type of Date in Redshift?
What’s the Field Type in Metabase? Admin > Data Model > (db) > (table) > (column) :gear:
What is the generated SQL? https://www.metabase.com/docs/latest/users-guide/custom-questions.html#viewing-the-sql-that-powers-your-question

@flamber

thanks for the update. Finally I solved the problem the next way:

When I add the second field I want to aggregate (not date) in resume is not working:

but after, I go to configuration -> Data -> add a serial breakdown and I add here my text field

now it’s working!

Thanks!