Counting items between a set of dates
Counting items between a set of dates
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?
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: Counting items between a set of dates
Hello,
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?
Thank you.
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?
Thank you.
Re: Counting items between a set of dates
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.
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.
Re: Counting items between a set of dates
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.
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.