platform analytics record producer variables

[LT_23]

Hello,

I have a record producer for which I want to use platform analytics to do reporting and I need help to be able to pull all the variables inside my record producer  but I am having a hard time to do so.If you could guide me on how I can go about displaying all my variables that will be very helpful, thanks in advance. 

[Tanushree Maiti]

Hi @LT_23 

To pull and report on variables inside a record producer using Platform Analytics, you can create a Database View. 

Refer: Reporting on Catalog item variables

[Ankur Bawiskar · Accepted solution]

@LT_23 

not possible directly in data visualization in platform analytics

you can create database view by joining your record producer target table and the question_answer table where the variable data is stored

Then use this database view table in your data visualization

see this

Help setting up a database view on incident & record producer variables 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[LT_23]

Thank you so much