Count Data in InfluxDB

Hi,

i am simply try to count Data in my inFluxDB for a given time period.

> SELECT * FROM daily_visitors
name: daily_visitors
time                device_id                        tag_id
----                ---------                        ------
1688072446000000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688072456000000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688072843000000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688072999000000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688073015000000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688073573132000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074086137000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074089134000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074091131000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074097134000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074534136000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074536139000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074539137000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074694140000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6
1688074705137000000 946933d31edf290c13ebdb9ec2ba2f06 6A-5C-C1-E6

This should be displayed as SUM or COUNT in a Gauge virtualisation but i didnt get it running.
It displays me only “0”

Anyone an idea what should i do?

cheers
Daniel