Forum Discussion
Incomplete data for YoY%
Hey! I am trying to visualize yearly change of the value. I encountered one problem, everything works fine until I get to the 2018. I've got missing data from April 2018 and it keeps on lowering...
Hi Adrianna
Do you have a date dimension? If you do then create a column in the date dimension like
FutureDay = if([Date]>date(year(now()),month(now()),day(now())) ,1,0)
Then Set a Page/Visual/Report filter to set this parameter to filter only 0.
Not sure if it will work if you add this to your KNF table, I don't see why not.
The problem is that such dates do not figue in my dataset - they are created as a calculation while I refer to the dates from the previous year :(