Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Searching Dimensions Items for multiple items

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

3 Replies

Avatar

Employee Advisor

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

Avatar

Correct answer by
Community Advisor

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

Avatar

Community Advisor

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