1 Reply Latest reply on Oct 23, 2018 9:35 AM by swaroop.gantela

    How to Lookup Previous Day Value from a Single Day Filter?

    Chad Clauson

      I have a single day (MDY) dashboard filter and I wanted to create a percent change table where my user can select a date from the filter. With a parameter, this isn't a issue. However, I'd have to update the parameter every day to get the new date which I don't want to do. With a single date filter, I can get the count for that day but I don't know how to reference the previous day count. Any ideas?

      Obviously, it isn't an issue getting the filtered day count, but I'm not sure how to utilize a lookup calculation for the previous date count.