Searching Dimensions Items for multiple items

Avatar

Avatar
Validate 1
Level 1
user_2007
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
user_2007
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
user_2007
Level 1

08-08-2018

hello,

after two hours, gave up on finding it in the Help. Please advise:

on the screen below, in the box Search Dimension Items, I'm trying to search for something, in SQL terms, Browser LIKE "Moz%" or Browser IN ('Safari 11.1.2','Microsoft Edge 16','Microsoft Edge 17'). Only single items work for me though. I thought the Syntax for Dimension Expressions section should help me but it appears to me that it describes something else, or else I'm too dense to get the hang of it

Search Dimension Items.jpg

not sure if this better be posted as a separate question:

with the above example, if I select a range of Browser Items and drop it on the Day column in the Freeform table to break down by days, I'm getting what is shown on the screen below. For each Day, the default view gives me only ten rows of Browsers. If I choose to Download CSV now, the report will only contain those ten rows per day. How do I change the Rows to the max value here for all days at once, instead of clicking on Rows for each Day? Or, even better, how do I increase the default setting for this value?

browser breakdown.jpg

thanks for your help,

-Sasha

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

07-09-2018

This is a case where datawarehouse is a better option. Easy to select date granularity and as many secondary metrics as you like. Also base it with desired segment. Then get email or ftp a nicely usable file.

In workspace, You would need to highlight each line item manually to allow a max 400 results per line. Then you could use right click expand all items. Try your method in workspace expand a bunch and start to add some more metrics will slow down to a crawl...

Workspace Nice tool, wrong one for this job...

GLTU

Answers (2)

Answers (2)

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

07-09-2018

The segment you define could do some simple regex if it helps...Screen Shot 2018-09-07 at 11.59.22.png

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

06-09-2018

SQL-like commands aren't available in workspace, however you could use a segment to combine similar items.

  1. Create a segment, name it 'Mozilla browsers'
  2. Under segment criteria, drag over the browsers dimension, and set the rule to 'contains Mozilla'
  3. Save the segment
  4. Drag the segment as either a dimension or dimension breakdown