Skip to Content
0
Aug 20, 2020 at 07:26 AM

input control single selection dont show current and previous year measure in chart

34 Views Last edit Aug 20, 2020 at 07:33 AM 2 rev

Hi All,

I have created a story where am showing Sales current year and and Sales Previous year in Line chart. with date(Month) as dimension and have created a Input control on Year. Suppose user selects 2020 he must see 2020 sale and 2019 sales.

But when i refresh report , On selection of 2020 only, I see only sales for 2020 and previous year not show for comparison.

When I select 2019 and 2020 I see 2019 sales and 2020 sale , with 2019 sales previous year under 2020 section.

Can some one suggest what is the mistake while design that i made.

Below is the Screen shot.

On selection more then 1 year, I see for 2020 and 2021 current year and previous year which is fine but on selecting single year ,I see only for selected year.

sales-2019-2020.png

On selection of only 2020, ideally i need to see both 2020 and 2019 sale data

sales-2020.png

But if i create a widget level filter on year i see what I should be seeing.

sales-2020-widget-level-filter.png

Attachments

sales-2020.png (17.3 kB)