Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Tickets open/closed by date

Hi

 

I would like to make an overview of all tickets that have been created/closed in the past period.

 

resource table:

  1. Ticket ID
  2. Creation Date
  3. LastUpdate
  4. State

When a ticket is created, it gets the status 'open'. When changes are made, the date of last update is modified. In this case the status changes to 'closed'.

 

Now the goal is to convert these data into an 'Stacked colum' chart and 'Line chart' to visualise how many tickets are closed per day/week/month. 

 

I have a limited knowledge of the past, but I get stuck all the time. When I try to do it myself I get results, but each time a complete result and not by date (screenshot).

 

Thank you in any case for those who could help me.

 

 

 

 

 

 

 

 

 

 

 

 

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous 

     

    What are the relationships between the 4 tables?Could you pls share some sample data with expected output?Remember to remove the confidential information.

     

    Best Regards,

    Kelly

    If I have solved your issue,pls mark my reply as answered!

     

  • darentengmfs's avatar
    darentengmfs
    Post Prodigy
    5 years ago

    Hi Anonymous 

     

    It seems like you have not defined the relationship between those tables, that's why the visual is showing total data.

     

    You can define the relationships in this panel. You just have to drag the and match the primary keys to the foreign keys.

     

    If you have no experience with relational models, please share a sample of your report.