Adding up values based on a date range

user049903
user049903
in Magic ETL

In Beast mode how would I add up criteria in another column based on a date range? Refer to my attached picture: I would like to have a pie chart for 2019 and 2020 that adds up the various values based on a date range. 

Comments

  • MarkSnodgrass
    MarkSnodgrass Coach

    You can avoid even doing a beast mode if you put your date column in the pie name and then adjust your date range filter to graph by year. This will group all of your dates by year and do the work for you. See screenshot.

    pie.PNGdaterange.PNG

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories