Hello!
My goal is to display information from the top row of a table and put it in a diagram. This top row changes every 3 hours. The table shows historic weather forecasts. And I would like to put the information from the most recent forecast into my diagram.
Currently, my diagram has a scroll bar and when used you can see all the data from all the rows in the table. Which I just want one row that correlates to the most recent Time Stamp.
Also, the Time is wrong - it's showing information from 19/12/2023 when it should be showing information from 05/02/2024.
This is the table it's taking the information from:
You can also see that the Display Key keeps changing and is never the same.
This is my Visio diagram:
Any help with this would be amazing!
An alternative solution would be using Dashboards and GQI.
This will give you more flexibility in filtering, sorting and selecting Top X in the table. You could then embed the dashboard in your visual overview.
The GQI query could look like this as an example.
Hi Amber,
I think it would make sense to have the latest values in separate parameters. This way you can just display the parameters instead of having to find the latest row. If this is a Skyline connector, you could ask Skyline to add this to the connector. This is most likely the simplest solution.
Hi Michiel,
As the latest parameter always has a different display key. I would be unsure how to do that.
Can you share what connector this is?
In addition to Wale’s suggestion, you can embed this dashboard in a Visio overview.