Counting items between a set of dates

[rcd]

I'm trying to set up an indicator to count bookings within the next week. What's the recommended approach? Should I use a stored procedure with BETWEEN, or can I use countif() in an expression?

[Lech Kulikowski]

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

[rcd]

Hi Lech,

I have a database with booking information. I am trying to display, on an indicator, a count of the bookings which will occur in the next week.

I am wondering whether I should set up an SQL query as a stored procedure, or whether I can apply some kind of filter in the dashboard.

Also; sorry for the repost.

[HighAley]

Hello,

If you need to show data for the next week on the whole dashboard it would be better to filter data in your SQL query.
The smaller amount of data will be processed by our engine faster.
Or you could set the Filter for the Indicator.

Thank you.