cancel
Showing results for 
Search instead for 
Did you mean: 

Jump to Dashboard - Date issue

MikeGre
8 - Cloud Apps
8 - Cloud Apps

Hello,

I have a trend graph that consists of 3 values: (example below)

MikeGre_0-1677176804992.png

I have applied a Jump-To-Dashboard in order to be able to show on a simple pivot table, a breakdown of the data per day for the selected month.

MikeGre_2-1677177242729.png

As you will notice (in red), in my example I selected Jan 23, and on the pivot table, it shows me data from Dec 2022 (in blue).

I have tried to exclude filters (via the JTD script), disable dashboard filters that affect the pivot, and it always brings data from the previous month if available.

The only thing that "fixes" this, is when I toggle off and on the period filter... Ideally, the proper data would need to appear in the first place, so I am trying to understand:

1. Why this happens?

2. If anyone else has encountered a similar issue and

3. If there is a way to solve this (apart from toggling on/off)?

Thanks in advance,

Mike

0 REPLIES 0