Hello everyone,
I searched long and hard for an answer to my question. I did find some threads which were similar but did not find the exact same problem as mine.
My goal is to have a table with a column containing the ticket ID (primary ID) and all free fields as columns in a flat structure so I can do visualizations for our tickets in Zendesk. This can be seen in the sketch below.
Ticket ID | Free field 1 | Free field 2 | Free field 3
------------------------------------------------------
1 | x | true | 2
2 | y | true | 13
3 | x | true | 3
4 | x | true | 3
5 | y | false | 7
I imported our Zendesk data through the "get data" function and in the Ticket.table we have two columns. One contains the Ticket ID and another column contains the free field data. This is all good so far. However, the free field data is being imported as a list of records. If I then use the expand function, the table I want will be formatted as follows:
Ticket ID | Free field.title | Free field.value
----------------------------------------------
1 | Free field 1 | x
1 | Free field 2 | true
1 | Free field 3 | 2
2 | Free field 1 | y
2 | Free field 2 | true
2 | Free field 3 | 13
etc.
While this kind of works, I run into some troubles with my visualizations due to the fact that I want to count tickets which must meet multiple requirements (for example: count ticket where (Free field 1 = x) AND (free field 3 > 5)). When I do this, I always get the value 0. This makes sense because the ticket has no flat structure and therefore the multiple parameters cannot be used.
I would like to be able to fix this in the "edit query" instead of with DAX if this is possible, this will save me a lot of time with the many visualizations I have to make in the following months.
Please understand that I am a newbie, but not scared to put in some work to get it working. If my description is not fully clear, please let me know and I'll add it in the comments.
Could anyone please guide me in the right direction?
With kind regards,
Tim
