want to have day/day last year numbers

julia_wang

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?

jaeW_at_Onyx

@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.