Published on InterSystems Developer Community (https://community.intersystems.com)

Home > DeepSee: Comparision with the previous year

Question
Eduard Lebedyuk · Jun 3, 2021

DeepSee: Comparision with the previous year

Is there a way in BI (DeepSee) to compare current value, to a value of a previous year?

For example I can hardcode this explicitly:

But I want in a widget to filter by year (1st column) and get the value for a previous year in a next column. YTY would be even better.

What MDX functions should I use? Examples?

#Analytics #Analyzer #InterSystems IRIS BI (DeepSee)
Product version: IRIS 2020.1

Source URL:https://community.intersystems.com/post/deepsee-comparision-previous-year