Hello! I'm with Stax.ai and we use GoodData to provide embedded analytics within our verticalized CRM platform. In our datasets, we have tasks and projects which have the following dates: • created_at • started_at • completed_at If a task has

created_at

but not

started_at

or

completed_at

, it's in the "To-do" status. If it has

started_at

but not

completed_at

, it's in "In Progress", and finally; If it has

completed_at

, it's in the "Done" status. I want to create a stacked area chart which shows the number of tasks by status each month. I expect I need to use Metrics and MAQL here to do so. The x axis is month and y axis is the # of tasks. At the end of each month, I need: 1. The total number of tasks created in that month (

created_at

is during the month) 2. The total number of tasks being worked on at the end of the month (

started_at

is set on/before the month but

completed_at

is either not set or after the month) 3. The total number of tasks completed in that month (

completed_at

is in that month). How can I set this up?

Hello Naru, This is certainly possibly to do within maql when creating metrics. You can set your metrics to filter using a WHERE clause to define the time period which your are looking for. EX: Select Tasks where month = THIS You can also use FOR PREVIOUS to compare previous time periods. If you are new working with MAQL you can find some great videos HERE on building metrics and working with the front end

I am very new to MAQL, thank you for the videos!!