topic Re: filter on Current year and previous year in Dashboards & Analytics Discussions

filter on Current year and previous year

KKR — Mon, 04 Mar 2024 09:10:41 GMT

Hi,

I want to present current year and previous year data on my dashboard using period Name. Could you please let me know how to write filter condition?

Re: filter on Current year and previous year

anurag — Mon, 04 Mar 2024 14:41:12 GMT

Hi @KKR Can you please review this video for your use case:

- https://youtu.be/XSw_tSu0XY4

Re: filter on Current year and previous year

RADSr — Mon, 04 Mar 2024 18:35:34 GMT

@anurag has the technique covered ( above ) but you might need some more information - do you want this to be a prompted comparison ( again, the video above ) or an ongoing running YoY comparison?

When you say "using period name" what do you mean? You want that to be the display? Or that is the only indication of the year?

The more specific the use case details the better targeted answer you'll likely get.

Re: filter on Current year and previous year

KKR — Tue, 05 Mar 2024 05:57:52 GMT

@anurag Thank you for your information, i want to represent the same data in my dashboard, could you please let me know how do you created $p1 and $p2 presentation variables?

Re: filter on Current year and previous year

anurag — Tue, 05 Mar 2024 15:16:04 GMT

@KKR

You can create LOV for the presentation variables p1 and p2 to populate them with the period name column from a table in Incorta.