problem with variables in Data Visualizations (zurich patch7a)

[dirkdp]

Hi Everyone,
I’m currently creating an new Data Visializations report from sc_task.

In first step it is possible to add the following:

Then I want to add the self created variables (added on the form):

Start date/time; End date/time; Subject of the meeting;

to the report.

Why is it not possible to add the variables as columns to the report?

Thanks in advance for looking at my question.

Greetings

[Ankur Bawiskar]

@dirkdp 

not possible to add

You can create a database view and then use that in your data visualization

Reporting on Catalog item variables

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

[Ankur Bawiskar]

@dirkdp 

Following up—were you able to review the shared approach and link?

Please let me know if any assistance is needed.

[Tanushree Maiti]

Hi @dirkdp 

Creating a Database View is the best practice for reporting on custom variables, as they store data in a key-value format.

Try this:

Report on Item Variables in the Service Catalog with a Database View

[Lori Eurek]

Just venting here, so we should have to change all of our 100s of built and previously working reports because this "new improved" functionality of Data visualizations is unable to get past the letter P (of our facilities variables)?  I think this is terrible functionality that has been introduced with the  Next Experience > Platform Analytics.  I would be curious to know how many customers are using this and how many are pleased with the 'new improved' functionality.