This post in the Tinderbox Forum prompted me to look more closely at the new Table View feature. (New to me. It's been out for a little while now.)
Table view works principally on children of a note or container. It also works on siblings, if there are no children of a selected note. It consists of the name of the note and a row of the values of its Displayed Attributes; so if tables are important to you it's probably worth thinking about what you wish to include in Displayed Attributes. (That's a whole other discussion.)
Since every post in the marmot is contained in a Month container, it was easly for me to select the April 2024 container, and then select Table from the View menu. This gave me a table of containing the name of each post and all their displayed attributes.
It wasn't exactly clear how to export this data, but I figured it out. In the Table view, select any row. You can't Select All from the Edit menu without having at least one row selected. With one row selected, then Select All from the Edit menu. Right-click anywhere in the table view and you'll get a contextual menu. Select Copy, and in the sub-menu, select the format you wish the table to be copied into, I picked Comma-separated values.
Then paste the table into any app that accepts comma-separated values, in my case Numbers. You get a nice spreadsheet with all your data. You may have to fiddle with cell formats if you want to do any further analysis.
In April 2024, I wrote 81 posts totaling 23,489 words (Word count seems somewhat off per-post, but it's close.) The Sentiment Analysis value varied from a high of 0.300000012, to a low of -0.800000009. What that means, I don't know. But now I can look at those two posts and try and figure it out.
You could write a dashboard agent to keep track of things like that on an ongoing basis, but I haven't done that yet. I may do so soon, just to learn more about Tinderbox.
Pretty cool.
Originally posted at Nice Marmot 09:43 Wednesday, 8 May 2024