Am having a lookup which is created based on 90 days data , once this lookup is generated i need to query this data based on days.
Ex : How many runs completed within 7 days or 15 days or 30 days as all these data are bundled within 90 days.
CompleteTime - this has the time value
lookup name - historical_data.
Any help on this would be appreciated
We would need more information to be able to help you. What's the search you're using to populate lookup? What all fields are available in the lookup table? Please provide some sample data from lookup (mast anything sensitive) and sample output report that you want to generate.