topic Re: Dashboard shows 2024 while data is only until 2023 in Insight Advisor

Dashboard shows 2024 while data is only until 2023

augustaszvirblis — Mon, 09 Sep 2024 11:59:02 GMT

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!

Re: Dashboard shows 2024 while data is only until 2023

Or — Mon, 09 Sep 2024 12:25:58 GMT

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

Re: Dashboard shows 2024 while data is only until 2023

F_B — Mon, 09 Sep 2024 14:20:36 GMT

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.

Re: Dashboard shows 2024 while data is only until 2023

augustaszvirblis — Mon, 09 Sep 2024 14:27:22 GMT

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.

Re: Dashboard shows 2024 while data is only until 2023

F_B — Tue, 10 Sep 2024 07:07:23 GMT

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

Re: Dashboard shows 2024 while data is only until 2023

augustaszvirblis — Mon, 16 Sep 2024 07:47:35 GMT

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?

Re: Dashboard shows 2024 while data is only until 2023

F_B — Tue, 22 Oct 2024 07:37:44 GMT

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.