Dashboard shows 2024 while data is only until 2023

[augustaszvirblis]

Hey there,

I'm having a problem where dashboard considers the maximum date to be 2024 whereas the latest date in the excel files I am using is 2023.

For example, this expression takes the maximum year ("Metai"):

Sum(
{$<
Rodikliai = {'Socialinė pašalpa iš viso'},
Periodas={'M'},
Metai = {$(=max({$<Periodas = {'M'}>}Metai))}
>}
Asmenys)

In my data (excel files) the latest date is 2023, but the expression shows 2024.

Thanks in advance for any help! 

[Or]

Without the underlying data, can't really help with this one.

[F_B]

Hi @augustaszvirblis ,

welcome to the community.

You'll have to check your data and app thoroughly to find what's wrong, you could start by using a simple table to display the distinct values of the Metai field to confirm what values are actually present.

[augustaszvirblis]

Thanks, good idea! What I did for now is a temporary solution where I subtract 1 from Year to get the year I want to see.

[F_B]

Let us know if you find a solution, or new clues on how to help you.

[augustaszvirblis]

The list of all years for that dashboard page includes 2023, 2024. Hmm does that mean that the underlying data includes 2024? Does data differ for each page of dashboard? Does that depend on the fields used?

[F_B]

Hi @augustaszvirblis.

"does that mean that the underlying data includes 2024?"

Assuming 'Metai' is a simple field loaded from an Exel file, it looks like 2023 and 2024 are values of your data source.

"Does data differ for each page of dashboard? Does that depend on the fields used?"

I'm sorry, I'm not sure about what you mean.