No se puede crear %1 en la vista "%2" porque utiliza el agregado "%3". Considere la eliminación del agregado, no indizar la vista o utilizar agregados alternativos. Por ejemplo, para AVG reemplace SUM y COUNT_BIG, o para COUNT, reemplace COUNT_BIG.
Click to search this error in Google
English version
Cannot create %1 on view "%2" because it uses aggregate "%3". Consider eliminating the aggregate, not indexing the view, or using alternate aggregates. For example, for AVG substitute SUM and COUNT_BIG, or for COUNT, substitute COUNT_BIG.
SQL Server