Searching Dimensions Items for multiple items

user_2007

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)

pabloc82923542

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)

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