Is there a way for Xcelsius to only select non blank cells in the excel model, where the non blank cells are dynamically changing over time?
I mean this as an alternative to preselecting data in the model, which I can make do what I am asking.
We are investigating a means to have Xcelsius only search for, and display the non blank cells in the excel model when loading. This is as a means to reduce load times when running the preview of the dashboard model, and only displaying the non blank data.
This has been a huge source of frustration for me. I'm at the point now where I am simply wondering if Xcelsius can even do this or not. Preselecting isn't exactly "dynamic"
Thanks all.