Hey I am pretty new to Qlik Sense and need some help with a task tracker. I have a table that has a list of tasks, their start dates and their completed dates and I am trying to develop two charts with this information. The first is a chart showing how many open tasks I had on at a time over the last year, with each week as a data point. If there was a task not completed prior to the week or started during that week it should be counted as open for the chart.
The second chart should show me the ratio of tasks started each week divided by the number of tasks closed that week. My dimensions are the task name and each date. I am unsure how to go about combining two date dimensions like this in a single line chart. Any assistance would be greatly appreciated!