Comments
-
Thank you @GrantSmith! I'm trying to pull enough data for comparative purposes (360 days rolling). What would be a good threshold time frame?
-
My solution is kind of a work-around but the basic idea is to use a delimiter to combine the columns and remove them later on: Add a comma (or another delimiter) to the end of each text column that need to be combined (e.g., cat --> cat,) Combine the columns (will look something like cat,dog,,,bird,,) Replace text LIKE…
-
@user12758 I ran into a similar problem where... I was also trying to calculate % of Total Unique Records but kept getting % of Total Records when I set up the calculation as COUNT(DISTINCT 'id field') / COUNT(DISTINCT 'id field') FIXED() I did what @jaeW_at_Onyx suggested (or at least a version of it), where I identified…