Compare the value of a field for two different dates (YTD, and this month compared to same month of last year)

[DanielH]

Hi @Brett,

Actually, I got help in another thread which helped me to find a solution:

Hide columns or rows in visual without filtering them out

Sorry, it’s not a visual for each calculated field. But a calculated field for each metric. I use this for WoW and YoY % change metrics. Both of these metrics along with 6 other metrics (multi-week averages, YTD Totals, etc) are in a single visual. This is usually put into a pivot table. I’m not sure how well charts would work. But most have multiple calculated fields to determine their values. For example, I want to display a WoW % change value. But it requires displaying the current and pre…

So this topic can be closed.

Thanks!