Hi Team, I'm new to GD, and I was trying to create...
# gd-beginners
g
Hi Team, I'm new to GD, and I was trying to create an KPI that tracks the user count MTD (Month-to-Date), comparing the current month's data with the previous month's data. However, the numbers in the KPI are showing a comparison between the total count from the previous month and the current month's total, rather than comparing specific date ranges. For example, when I check today, the previous month's total is 18,009, and the current count till date is 1,053. What I need is a comparison between the 1st to 11th of May (previous month) and the 1st to 11th of June (current month). Could you please help me set this up? If it's resolved, can you please share the link with me? Thanks in advance!
👀 1
m
Hi Ganesh, thank you for this, would you be so kind to share with us the direct link of the insight? (feel free to use DM)
Hi Ganesh, Thank you for your patience on this matter. Unfortunately, the Month-To-Date feature has not yet been implemented as a built-in option. I will submit product feedback on your behalf regarding this. In the meantime, I can propose a workaround. Using our technical user (as Admin), I have created a metric called TestGD:
SELECT count({label/customer_id}) WHERE ({label/order_date.dayOfMonth} < THIS(DAYOFMONTH,1))
and two insights: _TestGD_MTD_Table_ and _TestGD_MTD_Table_May._ Please note you have to use a Date Filter = This Month. The second table can be used to confirm the values for the previous period (in this case month). With this setup, you will be able to compare the current data to the same period last month. Please note that this is only a workaround and is not officially supported; thus, feel free to test before. Thank you for bringing this feature to our attention. Let us know if you need any further assistance.
p
🎉 New note created.