-
help with logic - finding unique number of `column1` that have BOTH value '1' and '2' from `column2`
I am struggling through working out the logic for this. Can anyone help me think through this? There might be an entirely different approach that is much easier. I am sorting out an email campaign and I want to know how many unique `EmailAddress` show up for BOTH `EmailName` value 'email1' and 'email2' at least 1 time. (To…
-
google analytics segment / user level data
Hi - My Session and Pageview data is correct when comparing DOMO imports to GA numbers for All Users. When I split this data down by imported segments, the data is incorrect. The segments are user-level Segments. My user data has never been correct, but I have been able to work around with correct pageview/session data Is…
-
How do I display Time (mm-ss) as a value in bar chart
Hi - I have tried to hunt down this answer but it is tough to phrase and I haven't found a solution. My time is in seconds, and I used the SEC_TO_TIME function to get a nice output - the data is exactly how I want it. In a table it looks like this: However, when I try to put this information into a Bar or Pie, it shows no…