Forum Discussion

Shravan133's avatar
Shravan133
Super User
2 years ago
Solved

Forecast data error - timeline not consistent

Hi,  I am trying to forecast growth of DB size by dates in a Line Chart. But i get an error saying the timeline is not consistent. Is there a solution to this?  
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Ritaf1983 ,thanks for the quick reply, I'll add more.

    Hi Shravan133 ,

    Regarding your problem, I think the problem occurs because the date column in your original data is not continuous.The forecast function requires consecutive dates.

    You need to create a date table containing consecutive dates and merge the data from your original data table into it.

    Table 2 = 
ADDCOLUMNS(CALENDAR(DATE(2024,1,1),DATE(2024,12,31)),"value",
VAR _result = SUMX(FILTER('Table',[Date] = EARLIER([Date])),[Value]) RETURN IF( ISBLANK(_result),0,_result))

     

    Best Regards,
    Wenbin Zhou

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Ritaf1983 ,thanks for the quick reply, I'll add more.

Hi Shravan133 ,

Regarding your problem, I think the problem occurs because the date column in your original data is not continuous.The forecast function requires consecutive dates.

You need to create a date table containing consecutive dates and merge the data from your original data table into it.

Table 2 = 
ADDCOLUMNS(CALENDAR(DATE(2024,1,1),DATE(2024,12,31)),"value",
VAR _result = SUMX(FILTER('Table',[Date] = EARLIER([Date])),[Value]) RETURN IF( ISBLANK(_result),0,_result))

 

Best Regards,
Wenbin Zhou