Forum Discussion
dwel0120
Helper III
Helper IIIBar chart - YoY comparison - Future Dates
Hello - I have a line/bar graph that tracks a number of people (Light blue line - previous year and dark blue line is the current year). The bars represent the YoY change. How do I write the formula ...
will it work if you put it as a filter in your calculate statments for current year and YOY?
claymcooper
Resolver II
Resolver IICreate a calculated column based on your date column:
Future Date = IF(Date > Today(), "Y","N")
Then filter your visual based on that column so that Future Date = N
dwel0120Helper III
Helper IIIclaymcooper That doesn't work because I still need it to show the PY line (the light blue line in my original post).
- claymcooper
will it work if you put it as a filter in your calculate statments for current year and YOY?
- dwel0120