Report query - GroupBy requested item variable in Platform Analytics data visualization

[Shantharao]

Hello All,

I have created a new report on the Requested item and I want to add "GroupBy" option as one of the Requested item variables in the Platform Analytics data visualization 
Thanks in advance for your support

[brahmandlapally]

Hi @Shantharao 

if you see in columns you will see Variables do dot walking and select your item and choose the variable you want.

Thank you.

If you feel my answer is helpful plz click on helpfull. if you feel my answer is Correct click on accept as solution.

[Shantharao]

Hi @brahmandlapally ,
Did you create a Data visualization by using requested items variables in the Platform Analytics?
When I chose the variable option in the columns, it has been showing loding......

If you created, could you please provide the step by step with screenshots

Thanks in advance for your response

[manishdutt]

Here’s a cleaner, step-by-step version you can share (with corrected wording and a bit more precision). Quick note: editing JSON directly is powerful, but it’s also a “measure twice, cut once” activity—take a backup before saving.

If you’re having difficulty adding variables via the UI

1. Go to the par_visualization table.
2. Search for your report/visualisation record using the report name (or the relevant identifier used in your instance).
3. Open the record and locate the JSON configuration field.
4. Amend the JSON to include the variable(s), for example:
   • Add entries like: variables.
   • Where SYS_ID is the sys_id of the variable you want to include.
5. Save the record.
6. Reopen/refresh the report and confirm the variable is now available/working as expected.

Suggested safety checks (recommended)

• Copy the existing JSON to a text editor before changing anything (easy rollback).
• Make one change at a time, save, then validate.
• If there’s a dev/test environment available, try it there first.

If you paste a small snippet of the JSON (redact anything sensitive) and tell me what you’re trying to add (single variable vs multiple, and where it should appear), I can help you structure the JSON change more safely.