I have used “Rollup” to count all rows in a table, but is it possible to count unique data? For example, when a search is made for a specific city, I aim to give a count for City A, City B, City C, etc. Thank you. BSS

Create a multiple relation column that matches the city name with itself, and then do a rollup through that relation.

That did it for me. Thank you so very much. BSS

Hello Darren. If I may, I would like to ask you another question. I have a table with a column name “Occurrence Date”. I am having two strange problems. When I use the “Generate a CSV” file the “Occurrence Date” column is not included in that file. Also, When I click the button to “Generate a CSV” f…

Does the Occurrence Date column has any values in your database? Is it set up as a date/time column?

Yes, the column does have data, and the field is set up as “Date Only” and “Medium”

Is it necessary for me to re-create the table?

That’s weird. If it consistently behaves like that I think you should report to support. [image] On a paid plan? Use Support chat in the Glide builder Ask for Help If you’re on a paid Glide plan, the best way to get help is by reaching out to our support team directly fro…

[image] Benjamin_Strickland: “Occurrence Date” column is not included in that file. Use select columns to decide which columns will be included in the generate csv action. [image] Benjamin_Strickland: I get an error message but when I click it again thereafter it creates the file. I’m…

I have discovered the error problem. In my Action to “Generate a CSV” file for the Attendance table, I had a “Wait” action above the “Generate a CSV” command and that was causing the error to appear. But I then moved the “Wait” action below the “Generate a CSV” command and that stopped the error. I …

[image] Benjamin_Strickland: I had a “Wait” action above the “Generate a CSV” There are 2 types of wait actions, one of them is wait for condition. It sounds like you are using “wait for condition” and the condition is not being met. The standard message is “error” if you do not include a cu…

Counting Unique Input

Ask for Help

ThinhDinh September 1, 2024, 11:04am 8

That’s weird. If it consistently behaves like that I think you should report to support.

Topic		Replies	Views
Generating Report Ask for Help	5	111	September 4, 2024
How to get total of rows based on a column value? Ask for Help	8	1565	March 7, 2021
Display the Count of items matched in a 'Relation' list Ask for Help	28	5136	October 28, 2023
Integration Generate CSV Bugs? Ask for Help	13	686	June 28, 2023
Select data/rows with same date Ask for Help	3	249	June 7, 2023

Counting Unique Input

Related topics