Hi all -- hoping someone can point me in the right direction.
I have a board that displays WoW revenue in relation to targets. Both Rev and Target are Metrics. Data for future weeks (based on standard Day) is null in Rev but populated for the Target Metric.
I want all future weeks to be displayed in a chart using this view, but nothing I’ve tried from Pigment documentation has worked so far. I’m trying to created a ‘helper’ Metric with a formula to return ‘0’ for future weeks where Rev is null, but ISBLANK and pretty much anything else I’ve tried hasn’t worked. Is there anything else I can try?
Thanks!