Date not going past current date

Reply
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

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
______________________________________________________________________________________________

View solution in original post


All Replies
Green Belt

 

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

Black Belt

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
______________________________________________________________________________________________

View solution in original post

Announcements
New & Improved Dojo: Get excited for a new feel and additional features in the online community.

Site will be down February 4-5th for maintenance.

Launch coming February 8th!