I want to create a report and Dashboard to compare the conversion rate of the previous week with this week.
How can I do that?
Thank you!
10 respostas
@Rajeshwari Jain Is this what you're looking for?
Formula A =
CONVERTED:SUM / RowCount
Formula B =
( CONVERTED:SUM / RowCount )
-
(
PREVGROUPVAL( CONVERTED:SUM , CREATED_DATE) /
PREVGROUPVAL( RowCount , CREATED_DATE)
)