topic Which performs better for date inclusion? in Dashboards & Analytics Discussions

Which performs better for date inclusion?

marcpaige — Mon, 20 Nov 2023 17:04:42 GMT

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

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

Thanks!

Re: Which performs better for date inclusion?

Shashidhar — Tue, 21 Nov 2023 14:49:16 GMT

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

Re: Which performs better for date inclusion?

amit_kothari — Wed, 22 Nov 2023 15:55:41 GMT

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