Forecasting

[kalpanaV]

When i executed below code, i am getting graph. why y axis is showing like this.

i want created date in x axis, ticket count in y axis

library(forecast)
data2<-data.frame(dataset)

# group searches by date
dataset <- aggregate(Count_Id~Created_Time , data = data2, FUN= sum)
summary(dataset)
# create a time series based on day of week
ts <- ts(data2$Created_Time, frequency=7)

# pull out the seasonal, trend, and irregular components from the time series (train the forecast model)
decom <- stl(ts, s.window = "periodic")

# predict the next 7 days of searches
pred <- forecast(decom, h = 7)

# plot the predicted searches
plot(pred)

[v-sihou-msft]

@kalpanaV

Can your verify your ticket count field? Does it contain "E-notation" in your source?

Does this issue occur in Power BI Desktop only? If so, can you share your .pbix?

Regards,

[kalpanaV]

Hi

I changed it to Created_Date now which is having only date.

library(forecast)
data2<-data.frame(dataset)
# group searches by date
dataset <- aggregate(Count_Id~Created_Date , data = data2, FUN= sum)
summary(dataset)
# create a time series based on day of week
ts <- ts(data2$Created_Date, frequency=7)
# pull out the seasonal, trend, and irregular components from the time series (train the forecast model)
decom <- stl(ts, s.window = "periodic")
# predict the next 7 days of searches
pred <- forecast(decom, h = 7)
# plot the predicted searches
plot(pred)

The thing  i want to understand in this graph is 

is X axis is Created_Date

Y axis is no of tickets?

[v-sihou-msft]

@kalpanaV

I don't quite familiar with forecast package either. Please refer to following articles for its usage:

Forecasting Functions for Time Series and Linear Models

Time Series Analysis using R – forecast package

Regards,