You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Report (Count Distinct - Accomplishments)

Received Response
1
Views
1
Comments
in Reporting and Analytics for HCM 1 comment

Summary:

Hello, I'm running an OTBI report.

Is there a way to use count distinct in Accomplishments?

Subject Area: Workforce Profiles - Person Profile Real Time

But the thing is, Accomplishments column is under Content Type. You just need to filter it.

Can filter + count distinct can be used? Please help me with this requirement.

Attached herewith is a copy of the XML.

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160">

  <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Workforce Profiles - Person Profile Real Time&quot;" withinHierarchy="true">

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!