Visualize data for the first 12 months of a customers tickets

[Anonymous]

Hello friendly community,

I'm trying to visualize the first 12 months of ticket counts and other behavior from my current data. I can create a DAX to find the earliest date, and could create multiple separate columns to capture the value at Date +1 Month +2 Month and so on, but I wanted to check with the group if there was an easier way to do this. We have a date_entered field in the data for each ticket entered.

See summarized behavior below (please let me know if I can help with more details)

Company_recid	2013	2014	2015	2016	2017	2018	2019
company 1	630444 (first ticket)
company 2			705099 (first ticket)
company 3							999032 (first ticket)

As always, appreciate any suggestions or help.

Regards,

Seth Calkins

[amitchandak]

@Anonymous , is it your raw data, this seems incomplete. Can you share sample data and sample output?

See if this can help https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

@amitchandak , I've trimmed down my data, and left it up with three companies as an example. Please feel free to take a look from the below link:

https://drive.google.com/open?id=1VV80CMtTQaMH5oW4VhdvWLSTdnIBvaFy

They all have different dates when they first started logging tickets. I'd like to visualize them all so the visual starts with "start date" then start date +1, +2, etc. for the first 12 months.

I'm working on the DAX to make 12 columns each to represent the sum ticket count for each companies first twelve months. If I complete that, I'll add it to model and share.

As always, very appreciative of the collaboration of this community, please let me know if I can help with any additional details or questions.

[Greg_Deckler]

A little vague but you might benefit from Open Tickets: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147