When using the table visual, if the database column is a string, the only aggregation option is Count. It would be great if Max was an option, that way we could actually see the value. I imagine it’s a quick addition and would be a HUGE help.
Hi @mml
you could change the datatype of the column or create a new int field with parseInt.
But what “value” do you want to see. Your shown field is a ID field. In that case Max(user_id) will only give you the highest number but not the actual number of users.
BR
1 Like
I have the same issue but in a pivot table. Sometimes we want to show a string as a value in a pivot table but it’s not possible. If we can use max or min on a text field, that would allow us to use it as a value.
@mml Since you’re not using a pivot table, can’t you put the text field in the “Group by” field well instead of the “Value” field well?
1 Like
Here are some other related topics:
The second one is from me.
Ah great, i was able to use the “group by”. thanks for your help!
1 Like
Is there any update on this? This seems pretty simple to do since it’s possible in SQL.
I even created a dataset in the right shape using a group by in SQL, imported the data, and still can only apply a COUNT() or COUNTDISTINCT().