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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Line Item Triming Option in Report Builder

Avatar

Avatar
Give Back 25
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Give Back 25
Establish
Contributor
Shape 1
Give Back 10
View profile

Avatar
Give Back 25
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Give Back 25
Establish
Contributor
Shape 1
Give Back 10
View profile
ashokkumarm
Level 5

17-07-2019

Current we have option to add prepend/postpend Text to Line Item in report builder.

By introducing Trim option in Line Item we can get better report.

Example: Pagename has captured as "SG:HomePage:Product1:SubProduct1", i only want to display "SubProduct1" in visualization. Currently we use excel formula to trim these data. Whenever Line Item has increased we need to manually extent these formula, due to these reason unable to automate some reports.

Regards

Ashok

3 Comments

Avatar

Avatar
Give Back 400
Employee
hyderziaee
Employee

Likes

231 likes

Total Posts

465 posts

Correct reply

222 solutions
Top badges earned
Give Back 400
Give back 300
Give Back 200
Give Back 100
Give Back 50
View profile

Avatar
Give Back 400
Employee
hyderziaee
Employee

Likes

231 likes

Total Posts

465 posts

Correct reply

222 solutions
Top badges earned
Give Back 400
Give back 300
Give Back 200
Give Back 100
Give Back 50
View profile
hyderziaee
Employee

18-07-2019

This is possible currently using classifications.

You can use Classification Rule Bullder to automate if the pagename is having a pattern as you have mentioned.

Avatar

Avatar
Give Back 25
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Give Back 25
Establish
Contributor
Shape 1
Give Back 10
View profile

Avatar
Give Back 25
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Give Back 25
Establish
Contributor
Shape 1
Give Back 10
View profile
ashokkumarm
Level 5

18-07-2019

Yes we can classify data in Adobe SiteCatalyst.

But users don't have classification option can get clear data when Adobe introduce this option.

And If we have many random criteria means its difficult to create many classification.

Regards

Ashok

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

358 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

358 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived