The post your read is correct: if you create a calculated field [Today] that is just equal to TODAY(), and then add it to the Marks shelf as a Detail, you should be able to use it as a reference line.
However, to get it working properly, you may have to do 2 additional things:
- Convert it to a Continuous Measure. It won't work if it's discrete (blue pill) when you add it to the Marks shelf. It must be continuous (green pill).
- You may also find that aggregating it, such as adding it as MAX([Today]), yields more predictable results than just adding it as a row-level continuous measure.
Hopefully the above will get it working for you.
Yes, thank you!! I was missing the making it a Continuous Measure piece, once I changed that it worked perfectly!
I was already able to do this, but till now I still cannot figure out (since one must specify Minimum, Maximum or Constant) how to get rid of the "Minimum" (or "Maximum) in the tooltip (note: I am aware the tooltip cannot be removed nor 'altered')
'Cos it does not make sense for it to show "Minimum Today = <whatever is the current date>"
Thanx & Rgds,