Skip to Content

2 year comparison in Webi

Hi, I have a problem. I want to compare data of 2 years. The scenario is I have a filter defined at universe level "Date Range" all i want is that user select date like 01/01/2016 and 31/12/2017 and it pick the year from this date and compare the data side by side with city name and month in the section.
The issue so far is 01.png that if there is no data in 2017 so it assumes 2016 as max and min year. As I used Min([Date]) and Max([Date]) for picking the year.

I want the result like 02.png. as there is date in both 2016 and 2017.

Any help will be highly appreciated. Thanks

01.png (13.4 kB)
02.png (14.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 23 at 01:37 PM

    you can achieve this with cross tab.instead of using min/max to get year you can create one variable with year () funciton to extract years.

    V year=Year[Date object]

    Add comment
    10|10000 characters needed characters exceeded