want to have day/day last year numbers

julia_wang Member
edited March 2023 in Scheduled Reports

Does anyone know how to create the calculated field for today/today last year ratio? am creating a pivot table and would like to have pre-july, after-july as comparison showing in the rows, and the value is the ratio...i tried today till now but cant find the way to get the number showing unfortunately..

 (is it something we can do in domo?


  • @julia_wang it would be helpful to know what columns you have on the axis of your pivot table. (post a screen shot).

    also please post the beast mode you've written and include data structure... makes it easier to guess where you're going wrong.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"