I use SheetJS (xlsx) to load Excel files in JavaScript (TypeScript). The usage is a bit peculiar and I forget how to use it easily, so this is a memo for my own use. manual https://www.npmjs.com/package/xlsx install npm install xlsx File r…

It is difficult to arrange graphs in a Tableau dashboard because it is hard to get the layout to look the way I want. The reason is that when you drop or move an object with the mouse, it does not enter the intended hierarchy, Because chan…

To aggregate data by month/week, first find the beginning date of the month/week of the date and GROUP by that beginning date. If the DATE_TRUNC() function can be used to get the head date, such as Google BigQuery, you can aggregate the da…

I had a need to use phpLDAPadmin, so I set up Nginx and PHP with Docker Compose and ran it there. This is a template memo for myself to prepare Nginx with PHP running on Docker Compose for the next time I want to use PHP on the web again. …