Hello, I tried to add UX view with chart to display only the last 7 days, I put the formula [Report Date]=(TODAY()-7) in Show if. but the error "Unable to find column ‘Report Date’ " is showing? Can you help on this?
Show If has nothing to do with what you want. Instead, you’ll need to use a slice.