I am trying to create an app that shows # tickets opened and # tickets closed on a given date. I have a single Ticket table that lists every ticket, including its Submit Date and (if it's Closed) a Resolve Date. I also have a Date Dimension table. At its simplest, I would need to show (e.g.)
'On 12/10/2018, Submitted: 300 and Closed: 320 tickets', which would then be part of a larger line chart.
I've tried creating a duplicate table, then using the DateDim table to join a date to the Submit Date of one, and to the Resolve Date pf the second table, but I'm getting a 'Duplicate Derived Field' error.:
Thanks for the help! This looks like an excellent start.
ps. In these examples, there are Order, Shipment, and Invoice tables. Would I be able to use the single table to generate separate Submitted and Resolved Fact Calendars as well? That will be a great option for users.