How to create report based on string value

[Dasari Srihari]

How to create create report based on string value and if 1st 2 values are unique then i want to show in one single line bar chart

Ex: HYD Campus - Main Block

Ex: HYD Campus - 12nd Block

Ex: HYD Madhapur - Block

Ex: Pune - Mumbai Main

Ex: Pune - Head office - Block

How to pull all HYD Campus  location tickets count in Bar chart of  single line and same for HYD Madhapur. In one single line of a Bar chart. How we can create this type of report using reports or PA

[AndersBGS]

Hi @Dasari Srihari 

You can create a var line chart report and then group by short description or whatever your string field is called. e.g. utilize the condition short description contains AND short description contains.  

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Dasari Srihari]

Hi @AndersBGS ,

Thanks for your quick Response

I have 10 different name with same location please find below

Location: 

HYD Hi Tech City - xxx -xxxx

HYD Hi Tech City - yyy - yyy

HYD Hi Tech City - zzz - zzz

HYD Hi Tech City - zzz - zzz

Above all i want to group by is it possible, to crate report like that, in single line i want show total HYD Hi Tech City count by using Report

2nd Location:

HYD Gachibowli 1Floor

HYD Gachibowli 2Floor
HYD Gachibowli 3Floor

Above all i want to group by is it possible, to crate report like that, in single line i want show total HYD Gachibowli count by using Report

2nd 

[AndersBGS]

Hi @Dasari Srihari ,

I got it - Basic you have three possibilities:

• Create  a substring function field to extract the name "HYD Gachibowli" and "HYD Hi Tech City".
• Utilize performance analytics instead. Here you can just add a count where condition is "HYD Gachibowli" OR "HYD Hi Tech City"
•  Create a hidden field and a script to capture "HYD Gachibowli" or "HYD Hi Tech City".

Below is created based on 1st solution:

Above is based on that the name length and start is consistent through out the locations. Otherwise you will get as below:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders