https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/OCI-Full-Date/m-p/137550#M24938 <P>If you are pulling data from a query, do the following:</P><P>&nbsp;</P><P>select (fields) from (table)</P><P>where table.datetk = date_dimension.tk and date_dimension tk &gt;= (select tk-30 from date_dimension where latest = 1)</P> Tue, 23 Jan 2018 21:04:11 GMT stephen2 2018-01-23T21:04:11Z https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/OCI-Full-Date/m-p/137258#M24865 <P>I have created several reports to show capacity and performance but I am having a hard time custoimize the date range in the OCI Reporting Chart. Currently I am using "[Advanced Data Mart].[Date Dimension].[Full Date]". This give me around 9 Months of data. How would I go about limiting this to say 30 days or 90 days? I have tried using some of the functions to no success.</P> Wed, 04 Jun 2025 14:09:04 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/OCI-Full-Date/m-p/137258#M24865 Nate00 2025-06-04T14:09:04Z https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/OCI-Full-Date/m-p/137550#M24938 <P>If you are pulling data from a query, do the following:</P><P>&nbsp;</P><P>select (fields) from (table)</P><P>where table.datetk = date_dimension.tk and date_dimension tk &gt;= (select tk-30 from date_dimension where latest = 1)</P> Tue, 23 Jan 2018 21:04:11 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/OCI-Full-Date/m-p/137550#M24938 stephen2 2018-01-23T21:04:11Z