Which performs better for date inclusion?

[marcpaige]

This came up in a conversation with one of my analysts.

Which of these will perform better in a filter?

1) Two filters: date1 >= $lastMonthStart and date1 < $currentMonthStart

or

2) One filter formula with and(date1 >= $lastMonthStart, date1 < $currentMonthStart)

Thanks!

[Shashidhar]

Hi,

Option 1 will perform better than second one. The reason is formula expression becomes additional load to the Incorta instead of using direct column as filter. But you can't see much difference if you compare/use both unless you have large datasets.

Otherwise you can use both.

Regards,

Shashidhar.S

[amit_kothari]

Agree with Shashi.  One thing to note is if the insight have multiple metrics which needs different filters then we would need formula filters .