scpradhan Member

I found the solution for this as there were (Non-breaking Space, ASCII 160) and (Zero Width Space, Unicode U+200B) characters in the text. So, replacing those characters helped. ' ' (Non-breaking Space, ASCII 160) Non-breaking space (' ') is a type of space that looks visually like a regular space but has a different…

Is there a way to fix this kind of issue?

Yes, there are other categories. There is no beast mode formula used on the metrics. I checked on the other metrics like spend and clicks. And it's not grouping correctly by any other metrics.

Hi @Manasi_Panov , I tried using SQUASH_WHITESPACE() function. It didn't help. @MarkSnodgrass , there aren't any fields on the sorting section. I am not sure what is causing the field not to be grouped into one.

Thank you so much, it worked.

Is there a way to minimize sampling in Google Analytics reports obtained through the API? Or any method to pull the data in Domo that is exactly reflected in the platform reports?

I will give a couple examples here to make it easier to understand: In case user selects 03/01/2019 - 04/30/2019 then previous period should be 01/01/2019 - 02/28/2019 (or 02/29 in case of leap year) then previous period should be 03/12/2019 - 06/15/2019 In case user selects 04/01/2019 - 06/15/2019 then previous period…

@MichelleH basically, in the ETL, we are pulling only the new data being appended in the input dataset and the partition is done by the date.

Actually the client wants to use global filter, want to see the changes in the card based on the selection. Is it possible?

But date range is not always static; its dynamic; user can select any date range from date filter.