How do I count the number of data items and display inline?

[BaltimoreTom]

I have this in a daily note:

Tickets: 37992822, 37991844, 38000617
---

What I’m trying to do

I want to show the number of tickets inline on the same page and also on a tickets page with column headers “Date” and No. of Tickets"

[scholarInTraining]

length(Tickets) should hopefully do the count for you.

TABLE WITHOUT ID
file.name AS "Date",
length(Tickets) AS "No. of Tickets"
FROM "folderWithTheDailyNotes"

Things to consider: what does your Tickets field look like on days with 0 tickets? If it doesn’t exist at all you’ll have to change the query to check for that - Dataview won’t want to find the length of something that doesn’t exist!
If you get numbers that don’t make sense, try wrapping your Tickets field in [ ] to make sure YAML/dataview knows it is a list. e.g. Tickets: [822, 844, 617]
You can always add a column to your table to display the Tickets field itself for help investigating something odd!
Good luck!