I am trying to do period over period calculations and everything works fine until I use a filter. In my view I would only like to show the most recent date with period over period calculations but as soon as I limit my date column using filter in the view to most recent date the period over period calculations disappear. How can I keep my period over period calculations and still restrict the time period shown in the table to be most recent date?
Note: This is a hourly view table that I am working with.