Expand my Community achievements bar.

SOLVED

Create segment from eVar values delimited by ":"

Avatar

Level 5

Hi Team,

Is there a way to extract vegetables from v10 = "fruits:vegetables:gram" in the calculated metrics?

Note: before & after vegetables, we can have other values along with fruits & gram.

 

Please ignore below query.

I have an eVar to capture the multiples values delimited by ":" for insance v10 = "fruits:vegetables:grams".  I want to create a segment of fruits, vegetables, & grams and want to use as metrics.

Note: I have a classification rule builder on same v10.

 

v10 classified as:

Apple

Spinach

Dal

 

classification rule builder on v10:"fruits:vegetables:Grams"

On report

V10(Dimension)    Metrics

Apple                     Fruits

Spinach                 Vegetables

Dal                         Grams

 

My need is to create a segment on metrics to group fruits, vegetables as separate metric. Any help will be appreciated

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

You can use classification of the evar to create segment. However, I do not understand how you will use them as metrics. Can you elaborate?

View solution in original post

7 Replies

Avatar

Correct answer by
Employee Advisor

You can use classification of the evar to create segment. However, I do not understand how you will use them as metrics. Can you elaborate?

Avatar

Level 6

Definitely sounds like something that classification rule builder would work well for. I am also unsure about the "metrics" part. He should be able to use most metrics with the classifications, but "grams" won't be treated as a number.

Avatar

Level 5

@brentrad @Khurshid_Alam 

 

v10 classified as:

Apple

Spinach

Dal

c

classification rule builder on v10:"fruits:vegetables:Grams"

On report

V10(Dimension)    Metrics

Apple                     Fruits

Spinach                 Vegetables

Dal                         Grams

 

My need is to create a segment on metrics to group fruits, vegetables as separate metric. Any help will be appreciated

 

Avatar

Level 5

@Khurshid_Alam 

We can use segment as metrics if event breakdown by segments, & we can use in the calculated metrics, pls see below SS.

dinesh_b_kumar__0-1613459133011.png

 

Avatar

Employee Advisor

The Classification Rule Builder and RegEx can easily classify the values as Fruits, Vegetables and Grams. Further, those dimensions can be used to create segments which can be pulled in a report as shown in your screenshot.

Avatar

Level 5

@Ishan_Sinha_ Yes RegEx will work. Let me put question in another way.  Is there a way to extract fruits from v10 = "fruits:vegetables:gram" in the calculated metrics ?

Avatar

Level 10
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?