Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Most combination for a search form ?

Avatar

Avatar
Validate 10
Level 2
vitalin58577727
Level 2

Likes

15 likes

Total Posts

69 posts

Correct Reply

3 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
vitalin58577727
Level 2

Likes

15 likes

Total Posts

69 posts

Correct Reply

3 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
vitalin58577727
Level 2

23-11-2018

Hello,

I have a question.

I would like to find out the most common combination for a search form that consists of several values.

Evar20
Evar21

Evar22
Evar23
Evar24

I want a combination of:

Evar20
Evar21
Evar22

Find out.

  1. e.g. ice search

Color : Evar20 { red,blue, orange, yellow}

Size: Evar21 {10,15,20,25,30,35}

Shape:Evar22 {waffle, cup}

Is there a way to find out with existing data?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

521 likes

Total Posts

1,020 posts

Correct Reply

256 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

521 likes

Total Posts

1,020 posts

Correct Reply

256 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
ursboller
MVP

23-11-2018

that looks as either a job for excel/raw data or change in the tracking setup...

excel with warehouse export:

export data using data wharehouse where you break down by desired dimensions.  this way you would get line items like "red|15|waffle|1" where the last number is your selected metric. use excel to sort by the metric...

change setup:

I would recommend that you weite the values all in one evar (either choose a new one or skip the existing 3 ones), especially if they really belong together (such as filter options).

to get the single dimensions you can still use clasifications (with regex rule builder) to split them apart for reporting. but having the values all in one evar would allow to show the top values directly in reports or workspace.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 10
Level 2
vitalin58577727
Level 2

Likes

15 likes

Total Posts

69 posts

Correct Reply

3 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
vitalin58577727
Level 2

Likes

15 likes

Total Posts

69 posts

Correct Reply

3 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
vitalin58577727
Level 2

25-11-2018

Hello, Urs,

thank you.

I thought there might be an internal variable that contains all that.

I'll have to create a new variable.

Beste Grüße

Vitali