Doug Creighton
08/29/2023, 2:14 PMSELECT COUNT( {label/user_id})
WHERE {fact/click_action_1}=1
Then I added the date = Today metric on the 'analyze' section
As it is morning I should be getting 0 users but I'm getting 100. In SQL, this works fine.
Suggestions on how to solve?Michael Ullock
08/29/2023, 2:43 PMSELECT COUNT ({label/user_id}) WHERE {fact/click_action_1}= 1
So the metric looks good, so it might be related to the date = Today filter you have applied. Perhaps you’re using the UTC timezone?
https://www.gooddata.com/developers/cloud-native/doc/cloud/customize-appearance/manage-timezones/Doug Creighton
08/29/2023, 4:42 PM