Skip to main content
Contributor ⭐️⭐️
Sep 28, 2022 6:10 PM UTC
Solved

Report on Objective Type?

I’m looking to build a report on Success Plans that includes the Objective Type (CTA Type) name. What field will allow me to pull this data in?

matthew_lind
VIP ⭐️⭐️⭐️⭐️⭐️
Sep 28, 2022 7:05 PM UTC

@Jacquelyne It sounds like you want to build a Report which includes properties of the CTAs within a Success Plan.

If that’s the case, then you should begin not with the Success Plan object, but with the Call to Action object. This is because a single Success Plan typically has many CTAs (1:many), and therefore the out-of-the-box Lookups will not let you traverse from Success Plan to CTAs (1-->many), but will let you traverse from CTAs to Success Plan (many-->1). Set a filter on your CTAs that the related Success Plan field is not null.

Bear in mind your output will include 1 row per CTA, and therefore each Success Plan may be represented by several rows.

Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?

2 replies

matthew_lind
VIP ⭐️⭐️⭐️⭐️⭐️
Sep 28, 2022 7:05 PM UTC

@Jacquelyne It sounds like you want to build a Report which includes properties of the CTAs within a Success Plan.

If that’s the case, then you should begin not with the Success Plan object, but with the Call to Action object. This is because a single Success Plan typically has many CTAs (1:many), and therefore the out-of-the-box Lookups will not let you traverse from Success Plan to CTAs (1-->many), but will let you traverse from CTAs to Success Plan (many-->1). Set a filter on your CTAs that the related Success Plan field is not null.

Bear in mind your output will include 1 row per CTA, and therefore each Success Plan may be represented by several rows.

Translate
Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?
Contributor ⭐️⭐️
Sep 28, 2022 7:32 PM UTC

Thank you!

Translate