Question

Person Id field in Data Designer

  • 24 January 2023
  • 1 reply
  • 19 views

Userlevel 1
Badge +2

I am trying to outline an Average of Session Count YTD with the data that has come into CS from PX side. When I use the report builder to outline Session Count by Month, I am able to do that and also add filters for Person Id where I exclude anything that contains specific email type such as gmail (As we get emails in Person Id field from PX). But in report builder I am not able to calculate Average Session Count by Year to Date. Since the formula field dosent allows me to sum the Count of Sessions and divide it by months for current year.

I then went into Data Designer and when I am trying to outline the object and put filter on Person Id, it dosen’t provides ‘Does not contain’ option and rather it only allows one specific value to be entered.

  1. Can the Person Id field be made to work like it does in Report Builder when used in filters. Such that it allows ‘Does not Contain’ as a option to exclude certain elements.
  2. Can the formula field in Report Builder be made more enhanced where the aggregation of the field can be used in the formula to create a new field.
  3. The data designer also has a limitation where we cant extract Year or Month from the date and use that to group by data. Can the Data Designer be enhanced to tackle Dates.

Note: I have already spoken to support on this and they stated that this is a limitation at this point.


1 reply

Userlevel 5
Badge +5

Hi @rkumar 
I can help with your question 1)
I’m not 100% sure, but I think the confusion is that you are treating Person ID as a string field, but it’s actually a GSID (lookup to the Person object), that’s why you are not seeing the filters you need.

See this example drilling down from Person to Company Person. If you select Person Id → Email, you can access the email field itself and apply for example the filter does not contain “gmail”.

 

Hope this helps

Reply