Forum Discussion
Created vs resolved Issues
Hello Friends, I have looked at several articles about Created vs resolved tickets and could not find the right solution. My goal is to just have a line chart with Total count created and Total...
Thank you for your reply. Yes i did create the date dimension like i said above but did not work. After several attempts i realized that datatypes were not matching, once i changed that to Date type it started working. Yay.
Hi, Anonymous
What is your data model like?
Does the data for Created and resolved tickets come from the same table?
If they are from different tables, you need to create a date dimension table and establish the relationship with them.
Best Regards,
Community Support Team _ Eason
Thank you for your reply. Yes i did create the date dimension like i said above but did not work. After several attempts i realized that datatypes were not matching, once i changed that to Date type it started working. Yay.