If your data contains date information, you may want to see how your data changes by day. To see day trends in your data:

  1. Right-click a column in your grid that you would like to trend.

  2. Select Trending | Day Trend.

  1. Select the column you want to rollup for the day trend. Data Access Studio will automatically populate this field with the column you select in step 1.

  2. Select the date column you want to use.

  3. Choose how you want to trend: Sum, Count, etc.

  4. Choose the column you want to use as the ranking quantity. E.g. Sales Quantity. If you selected Count in the previous step, then this field will be hidden.

  5. Click Ok.