Forum Discussion
Forecasting with irregular dates
I am trying to forecast, but recieve the message that my data is too irregular to do so. Having looked at past solutions i can see that this link shows how to fix the issue: http://www.erikhudzik...
I tried this, however it doesn't seem to work.
I have connected my date table to my sales table - joining the date fields. so in theory when i add the date value to a line chart it should show every date from the past two years, but it doesnt, hence why my forecasting isnt working.
Is there any reason this wouldnt be working?
This is strange...
So i added my date (from date table) and revenue into a visuals table, then made sure the table was showing items with no data. Then i converted this to a line chart, which still has "show items with no data" checked, but on the chart itself it is excluding all dates with no data.
Is there any reason for this? as far as i can see it should be showing all items.