Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
Need idea to show the trends for :
I have tickets with opened and closed dates - based on opened dates ,we find the count of tickts opened in week 1 ,2,3... ( created separate column as opened week number
and thus calculation total count week wise) and similarly based on closed dates,we find the counts of tickes closed on week 1,2,3... ( created seaprate column as closed week number
and thus calculation total count week wise)
1. I need to show closed vs open ratio weekly view trend. total opened/total closed on weekly basis trend chart
Problem is how to show the trend . What to use in x axis? open week num or closed week number. Any way to merge the week?
PS - to get the total open tickets week wise - we are simply calculating the (counts of open week num - calculated from open dates) and same for closed counts (counts of closed week num- calculated from closed dates.).Hence two different columns we have for weeks.
Hi @FaisalImam ,
You will have to use the calendar table and in the same calendar table you will have to create three calculated columns :
WeekNum
Opened
Closed
And then create a measure to calculate %.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Can you please explain via small expample... Which type of calender should I ceate?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |