RangeSum Question

Anonymous — Tue, 28 Nov 2017 14:16:22 GMT

Hello,guys.

I have firsft funnel chart with measure: RangeSum(Below(Count(distinct lead_id),0,RowNo())).

And second funnel chart with measure: Count(distinct lead_id).

I have good result for stages: Успешно реализовано, Договор подписан, Подписание назначено, Бронь закончена, Забронирован, Показ совершен.

And I have differens result for stage Показ назначен!

For stage Показ назначен I have 109 unique lead_id in second funnel chart (measure Count(distinct lead_id))

So, I expected that this 109 unique lead should muliplate with 812 value in previous row on first funnel chart (measure RangeSum(Below(Count(distinct lead_id),0,RowNo())).

But I have 849 value in first funnel chart on Показ назначен stage.

Can you help me? I don't understand what 849 value means.

Re: RangeSum Question

Anonymous — Tue, 28 Nov 2017 22:02:24 GMT

And I tryed change order and the result got correct!

My measure:

if (ВоронкаПродаж = 'Новое обращение', count(distinct lead_id)

,RangeSum(above(Count(distinct lead_id),0,RowNo()))

)

How order can change result?

My sorting formula:

Match(ВоронкаПродаж,'Закрыто и не реализовано','Новое обращение','Назначена/Принят', 'Принят в работу','Потребности выявлены','Показ назначен','Показ совершен','Забронирован','Бронь закончена'

,'Подписание назначено','Договор подписан','Успешно реализовано')

topic RangeSum Question in App Development

RangeSum Question

Re: RangeSum Question