Greetings!
I'm trying to do some profitability analysis on various types of work (Projects, Support Cases, etgc) via an Analytics Dataset / Workbook. My Dataset is based on Time Entries as the core record type. In this specific use case, I only want to return Time Entries that are logged against Support Cases.
In the "Time Tracking" set of fields in my Dataset, "Task" seems to be the closest object that can be selected (which makes sense… the field on the Time Entry record is a single List/Record that allows a user to pick from Tasks, Project Tasks, Support Cases, Events, etc.).
In the joined records of the Dataset, I have options to dig down into:
- Task
- Task Campaign
- Task Event
- Task Phone Call
- Task Project Task
- Task Resource Allocation
Support Case (or just Case) is not an option.
Each of these does have a field for Support Case (ie: task.supportcase, calendarevent.supportcase, phonecall.supportcase, etc). But none of them actually seem to return results (in my Workbook, it just says "no support case" when I try to include one of these).
The closest I seem to be able to get is if I include "Task" from the main Time Entries section, and then filter out any Tasks associated to Projects (which leaves me with only CRM tasks and Support Cases, since we don't use Events, Phone Calls, etc). But that feels clunky and still not what I need.
Am I just missing something really obvious? In a saved search I could do a CASE statement in SQL to do "support case internal ID is not null" and ensure I only had Time Entries logged against Support Cases, but that doesn't seem to be an option here.
Suggestions?