Accessing Pulled API Report List Data

[Caiz]

I'm new to Power BI, and I have successfully connected FreshDesk to my Power BI Desktop. I have retrieved the a Ticket table which has a single column of a List of Records. When I click on one of the Records, it expands to have the columns Name and Value. The Name column has rows including subject, type, company_id etc. of that ticket. 

How would I be able to count the number of e.g. Open Tickets overall?

Any help would be greatly appreciated!

[Anonymous]

Hi @Caiz,

Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng

[lbendlin]

once you have your list of records, convert it into a table. Now you have a single column table of records.  Next you expand the records column, picking the attributes you want.  That will create a data table which you can then ingest in Power BI to do your visuals against.