there is no date having 1970 in my data frame in the date colum but when i plot it shows 1970

General
1

i have downloaded data from excel and date is not having 1970. but when i plot it shows 1970.bd<-read_excel("breakdown_22_23.xlsx")

bd<-bd%>%mutate(date=as.character(date))
head(bd)
e area fault_type machine unit description period

1 2022-04-02 MOUL~ M PR CLEV~ PR CYLINDE~ 15
2 2022-04-02 MOUL~ E COOLIN~ VW3 ~ VW3 COOLIN~ 12
3 2022-04-03 MOUL~ M MAIN M~ PAD MAIN M/C P~ 23
4 2022-04-04 MOUL~ M TURN T~ BOLS~ T/T BOLSTE~ 37
5 2022-04-04 MOUL~ M PR WHEEL PR WHEEL L~ 12
6 2022-04-05 SAND~ M BC 707 SPID~ BC 707 SPI~ 23

image
image844×464 4.19 KB

2

I think we need to see more of your code code and some sample data. See
FAQ Asking Questions

A handy way to supply some sample data is the dput() function. In the case of a large dataset something like dput(head(mydata, 100)) should supply the data we need. Just do dput(mydata) where mydata is your data. Copy the output and paste it here between
```

```

Why are you doing this?

bd<-bd%>%mutate(date=as.character(date))
3

1970 is the "start of time" in some systems. Do you have a blank or 0 in your dates?