PM25 | OpenSource Node Server Monitoring Platform | Monitoring library

I finally found the cause, almost by accident...

The new laptop on which I wanted to use Rstudio has a brand new installation of Windows 10 Pro. I seems that, by default, in "Region Settings" window the beta feature "Use Unicode UTF-8 for worldwide language support" is activated. This results in the previous error message when compiling a kable(Extra) with UTF-8 characters in PDF. Unselecting it solved the issue.

If you look at the Date documentation, you will find that the date parsing will differ depending on the host machine. This explains why it works in codesandbox and not in your machine.

Quoting it:

parses a string representation of a date, and returns the number of milliseconds since January 1, 1970, 00:00:00 UTC or NaN if the string is unrecognized or, in some cases, contains illegal date values (...) There are still many differences in how different hosts parse date strings, therefore date strings should be manually parsed (a library can help if many different formats are to be accommodated).

My recommendation is to use Momentjs to parse and handle the date. It also helps you format your output, so you don't have to do it yourself:

You are getting the correct thing in your console, it shows you that you get an array. The contents just happens to be undefined.

Not so sure what the problem is - I feel that from your question you should know the answer...

I'd use color aesthetic instead, because there are not many shapes that have a fill.

And there is a scale_(*aes*)_manual for each aesthetic. I have added this, although the values 1:6 are pretty random.

First create a Quarter column from original Date column

Using groupby also changes the structure of my data: instead of being sorted by 1/1/19, 1/2/19, it is sorted by 1/1/19, 1/10/19, 1/11/19.

This is because your Date column type is string not datetime. In string comparison, the third character 1 of 1/10/19 is smaller than the third character 2 of 1/2/19. If you want to keep the original sequence, you can to the following

I did it on postgres.
First of all you have to have type represents your data:

You need to correctly set the APN name with the command

The SQLite provider for EntityFramework will not create the database or add missing tables automatically for you. You can call dbContext.Database.EnsureCreatedAsync() to make EF create the database file if it does not exist. It will then also create all the required tables. However, if the file already exists, it will not modify it.

If you want to add additional tables to your database at a later time, you should consider using migrations which allow you to evolve your database schema over time while providing means to migrate from older versions of a database to the current schema.

If you have migrations set up, you can call dbContext.Database.EnsureMigratedAsync() to apply pending migrations to the database and make sure that the database matches the model you expect.

You can also create the database or apply migrations using the dotnet ef command line utility.