cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Generate spiceworks Tickets report

Hello I annoy you because I need to generate a list of incidents uploaded to the spiceworks cloud system and indicates that to generate lists and reports recommends using Power BI.

Additional fields called address, incidente_origen, etc. were generated to the spiceworks help desk structures.

There are 6 custom fields.

I now have 13 tickets uploaded and in the tickets detail table there are 13 records. In the custom attribute tickets table generate a record for each Custo Field and there are more than 30 re. This is seen in the first image.que attached.

Now I do not know how to generate a report that in the same line puts all the information corresponding to the same ticket. The second image is seen.

Can you help me?

D

caso1.jpgcaso1a.jpg

3 REPLIES 3
tjbennett
New Member

I am looking to have a Spiceworks Ticket report that shows the ticket (and description) with the comments pertaining to that ticket indented under it. Has anyone come up with a smilar report?

aallanaok
Regular Visitor

Hello Caitlyn Yan, thank you for answering my question. In the attached image you can see that the lines are repeated for each number of tickets. just changing the information in the "Ticket Custom Attributes" table. The tables are unit by the ticket number but I can't do to see all the information in the same line. I don't know if I was clear in my explanation? caso1b.jpg

v-caitlyn-mstf
Community Support
Community Support

Hi @Syndicate_Admin ,

 

I'm not sure I've understood your needs accurately.
Do you expect the output to be like the second picture?

You can try to create this list by using table visual and dragging all the required fields into this visual.

 

If I have not understood your needs correctly, please do not hesitate to inform me.


Hope it helps,


Community Support Team _ Caitlyn Yan


If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.