I’m trying to report on Automation Hub data in Insights. What I need is all of the Q&A data to be available as their own columns. So if I make a report that shows both Idea Type and Launch Date, those show as a single row connected to the main idea. Since the Q&As aren’t set up as their own individual fields, I see 2 rows when I make this report: row 1 for Process A shows the Idea Type question and answer, and row 2 for Process A shows the Launch Date. But they create duplicate rows and they can’t be filtered or sorted.
This is not a Pivot Table or Grouping situation that I can see, it’s just data that should be all linked directly to the main idea/process as columns. When you add in needing data for estimated benefits, or reporting on different salaries for all of your processes, this goes from annoying to unusable.
Has anyone figured out how to work around this? This strikes me as just a terrible data model in how Hub transfers to Insights. It makes reporting in Insights from Hub near unusable for any realistic situation I can think of. It should work the way Hub works in Automation Pipelines, where every field in the Q&As are a separate selectable column in the report. I don’t understand why the Insights data doesn’t do the same translation, it seems like a missed requirement for the Insights team to set up a usable data model from Hub.