code: def sum_in_date(x='date', y='net_sales', filter_dict=None, model='WikiItem', app=DEFAULT_APP, sort=True, limit=100000):
      
      sort = sort_prefix(sort)
      model = get_model(model, app)
      filter_dict = filter_dict or {}
      objects = model.objects.filter(**filter_dict)
      # only the x values are now in the queryset (datetime information)
      objects = objects.values(x)
      objects = objects.annotate(y=djmodels.Sum(y))
  
      if sort is not None:
          # FIXME: this duplicates the dict of lists sort below
          objects = objects.order_by(sort + 'y')
      objects = objects.all()
      if limit:
          objects = objects[:int(limit)]
      objects = util.sod_transposed(objects)
      if sort is not None:
          objects = sorted_dict_of_lists(objects, field_names=['y', x], reverse=bool(sort=='-'))
      if not x in objects or not 'y' in objects:
          return [], []
      else:
          return objects[x], objects['y']
docs: Count the number of records for each discrete (categorical) value of a field and return a dict of two lists, the field values and the counts.
  
      FIXME: Tests need models with a date field:
      Examples:
        >> x, y = sum_in_date(y='net_sales', filter_dict={'model__startswith': 'LC60'}, model='Permission', limit=5, sort=1)
        >> len(x) == len(y) == 5
        True
        >> y[1] >= y[0]
        True