![]() ![]() We pass this to strftime, which is SQLite's function to cast strings to a DATETIME format. In our example dataset, we have hourly data over five years, which is a bit too fine-grained to create useful graphs, so we take a substring of the first seven characters of our data column, which gives us something like 2018-06. "Total UCLF" AS decimal )) AS "unplanned capability loss factor" FROM "eskom" WHERE "eskom". "Total PCLF" AS decimal )) AS "planned capability loss factor", avg ( CAST ( "eskom". "Date Time Hour Beginning", 1, 7 )) AS "date", avg ( CAST ( "eskom". Choose "Eskom" (or whatever your database is called) using the dropdown in the top left and then enter a query. In the following screen, you'll get a SQL editor. In the top right, press "New" and then "SQL query". We'll ignore it and create our own queries using SQL rather. Unfortunately, because SQLite doesn't have a proper date-time field, automated analysis of date-related data is not very good. On the main page, you'll see Metabase has already set up some automated analysis for you. Connect to the database.Ĭomplete step 4 and then press "Take me to Metabase". If you're using the same data and structure as we did above, the path will be metabase-data/eskom.sqlite. Search for "sqlite" and select SQLite in step 3.Įnter the path to your database. Then you'll need to link the SQLite database we created in the first step. The first two steps are to set your name, language, and a password to access the Metabase admin panel. Visit your domain (for example, ) in your browser and go through the set-up wizard. If you like Certbot, please consider supporting our work by:īefore we use Metabase, there's a once-off set-up step. Successfully deployed certificate for to /etc/nginx/sites-enabled/Ĭongratulations! You have successfully enabled HTTPS on ![]() If you prefer using your own machine, you can do many of these steps locally and then transfer the files to the VPS using SCP, Git, or whatever method makes you happiest.įirst, make sure you have SQLite installed by running the following: To keep the examples simple, we'll do everything directly on the VPS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |