How to MTD, YTD in Apache Superset?

Question

I would like to create a dashboard with month to date (MTD) and year to date (YTD) charts. However, I do not want to update my date range each month. A fixed date range would do this. Choosing 1 months ago give the last 30days. Using last month gives me last month and everything from this month. Yet, this month is not supported. MTD doesn't work either. I am using Superset version 0.24.0

Climbs_lika_Spyder · Accepted Answer · 2019-04-01T17:18:55.640

4

I figured it out! Use 1st for MTD and Jan 1st for YTD.

For newer versions of Superset, this quarter is supported for quarter to date (QTD) charts.

edited Apr 01 '19 at 17:18

answered Apr 16 '18 at 17:13

Climbs_lika_Spyder

6,004
3
39
53

1

chaisng on old comment - are you able to elaborate on the solution. Where did you use the `1st` and `Jan 1st`? – CeeVei Jun 19 '20 at 03:59
anyone using superset version 1.4? 1st now gives YTD instead of MTD. – Adham Nm Mar 29 '22 at 06:53

score 0 · Answer 2 · answered Aug 24 '20 at 10:30

0

I think it can be set on the custom tab of the time range in the chart explorer. There you can use 1st and Jan 1st as strings that are parsed.

answered Aug 24 '20 at 10:30

J. Hunter

1

score 0 · Answer 3 · answered Sep 24 '20 at 20:11

0

TO get MTD put 1st in the 'Start' field and put this month in the 'end' field

answered Sep 24 '20 at 20:11

malcomwilk

1

score 0 · Answer 4 · answered Dec 22 '22 at 00:55

0

Select Range Type as "Advanced", then enter "1st" for Start Date and leave End Date blank. Image has today's date as End Date but leave it blank to get YTD

TIME RANGE dialog showing YTD entries

answered Dec 22 '22 at 00:55

pdxrlk

258
1
6

How to MTD, YTD in Apache Superset?

4 Answers4