Count attribute field

Question

Hello everyone:

I have a postgresql data set with some fields with attribute value metadata so I need a table to count the recurring data crossed with the row but I not found the option, any clue of this?

Answer 1

Field should be defined as measure in metadata in order to perform aggregate and mathematical functions

Comments

Thank you, but it is "string" de kind of field I want to count. I already tried to configurate as messure but display an error.

Thanks for the response.

---

You will need some aggregating in your query.
Basic syntax is as follows

Select
Count(Fieldname1) as CountOfFieldname1,
Fieldname1
From table
Group By Fieldname1

If you need something more, you can read about Common Table Expressions and SQL Windowed Funtions

---

So, there is not a direct function in knowage to achieve it.

---

Thanks, was helpfully!!