Is there any metrics in GoodData that first_visit_...
# gooddata-cloud
c
Is there any metrics in GoodData that first_visit_date between the date filter
k
Thinking completed In GoodData, you do not need complex MAQL date-comparison syntax to filter for records where
first_visit_date
falls within a date filter range. Metrics automatically evaluate within the context of the date dimension connected to the dashboard date filter [Slack thread]. To set this up: 1. Create the Metric Create a standard count metric for the entity (for example, user or player ID):
Copy code
SELECT COUNT({label/player_id})
If you want the metric to respond only to the date filter and ignore other dashboard filters (like region, status, etc.), you can use:
Copy code
SELECT COUNT({label/player_id}) WITHOUT PARENT FILTER EXCEPT {first_visit_date}
[Slack thread; Slack thread] 2. Connect the Dashboard Date Filter 1. In your dashboard, add or edit the Date Filter. 2. Connect the filter's dimension to your
first_visit_date
date dataset. 3. Choose your desired date range (e.g., This month, Last 30 days, or a custom interval). Once the date filter is mapped to the
first_visit_date
dimension, GoodData automatically scopes the metric to only include records where
first_visit_date
falls within the selected range [Slack thread]. 👍 0 button 👎 0 button â„šī¸ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.
c
can we update the metrics to SELECT COUNT({label/player_id}) where first_visit_date between the date filter in the dashboard. Currently the date filter in dashboard is for bus_date which for each player per day, not for first_visit_date
We want number of the first_visit_date in the period but also need all activities for the player in the period.