0

Queries to date pulls through in random rows


Avatar
Anne Mui

Data gets pulled in the middle of all rows


A

Activity Newest / Oldest

Avatar

Antonio Barral

Status changed to: Closed

Avatar

Antonio Barral

Status changed to: In progress

Avatar

Anne Mui

Hey Antonio, please ignore those yellow columns as those are my formulas. If you look at the last few rows, after 31/1/2021 it pulls 4/9/2020 then to Jan 2021 again. There isn't an issue with the query. It's the outcome of the query that is weird.


Avatar

Antonio Barral

Hi Anne,
If you have activated the "include empty data" and the "replace blank for 0" options, the query will include dates in which there are no values. If you sort by date in this query, these empty rows will be fit in their corresponding position.

Let us know if your doubt is solved or if you need something else!!


Avatar

Anne Mui

hey Antonio, thanks for this! I sorted by date and that solves the issue. When I tried to pull the query to yesterday again, it says query returns no values


Avatar

Antonio Barral

Is it the same query with the end date equal to yesterday? We have tried and the query returned data. Can you send us the query you are executing with the "Report an issue with a query" functionality?

Could be that you are using some filters that make the query returning no data?

Another possibility could be you need to activate the "Avoid GA sampling" to have more precise data. Sometimes if that option is not activated, data vary in each query even if the parameters of the query are the same.


Avatar

Antonio Barral

Hi Anne,

It is not very clear what is happening. Are the "False" values the problem? What is the difference between the yellow and the white columns? Are the dates with empty data the problem?
As I can see in the left picture, you choose 5 metrics. Are the yellow columns from another query or are they printed by the query? (when the query should not print it there).

Please, explain the problem by being more specific so that we can find the error and help you!
Thank you in advance and sorry for the inconvenience.