Date not going past current date

Reply
Highlighted
Yellow Belt

Date not going past current date

I'm trying to make a card that shows what 25% growth looks like within the next year. It should increment by month. For some reason, when I input the points into the analyzer, it stops at the current month. It should work because the Date column goes up to the year 2030 and the other columns that I need to fulfill the visualization are in the correct cell and years. I had it working before but we had to update our data sources and now the date can't seem to go past the current date even though I'd change the date filter to go beyond that. 

 

 


Accepted Solutions
Black Belt

Re: Date not going past current date

I would also check any other filters on the card, make sure that if you are filtering for say "store number" or "Country" or something like that, the filter may be blocking the future looking dates in your dataset.

 

Try pulling off any filter and see if that provides the forward looking dates.


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________

All Replies
Orange Belt

Re: Date not going past current date

 

There could be null values in the current month, I would check that to make sure the calculation is valid

Black Belt

Re: Date not going past current date

I would also check any other filters on the card, make sure that if you are filtering for say "store number" or "Country" or something like that, the filter may be blocking the future looking dates in your dataset.

 

Try pulling off any filter and see if that provides the forward looking dates.


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!