Monthly and weekly forecast view

White Belt

Monthly and weekly forecast view

So i have a dataset linked to a forecast file that contains weekly numbers as below



when i graph it weekly i used sum distinct(forecast) for Y axis or else it would sum every line up or average it which is not right, how do i show it in a monthly view in the card filter without changing the Y axis?


Black Belt

Did a tutorial on this topic on my YouTube channel.  Good luck.

Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
I see so many people struggle with combining datasets in Domo. This is the right way to do it! No weird JOINS. No complex #BeastModes. Just super simple #Mag...
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.