Time Intelligence in DOMO
Is time intelligence possible through Beast Mode? Meaning is row level context possible - if the date on the current row is 1/1/2019 can a measure effectively be instructed to go back exactly one year and grab that value and insert it in the row? Attached is an example data set where I would want a PY measure.
I've tried to follow the exact instructions below from the URL below but have not had success. : https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Period-over-Period_Transforms#YOY:_Multi-Period_Comparison
In reading through the measures, I'm not seeing where logic is applied at the row level that would give DOMO context to go back a certain internval to grab the prior year amount.
Thanks in advance!