Anybody please ?
I am missing what you are trying to do here ... how are you trying to optimise your dashboard, do you just want to add a label, do you have a sample workbook?
Please refer the last point of 'Calculation Tips' here: Create Efficient Calculations
"Remember that all basic calculations are passed through to the underlying data—even literal calculations like label strings. If you need to create labels (for example, for column headers) and your data is very large, create a simple text/Excel file data source with just one record to hold them so they don't add overhead on the big data source."
In my dashboard there are few labels and I wanted to create such a single row dummy data source for optimization. Kindly let know for further clarifications.
Can you share a workbook?
Sorry for delayed reply. Actually I have been thinking on sharing the workbook you asked about. To reproduce the issue with a dummy would be huge to upload, and if I share a sample set then the performance issue would not be reproduced. So, may I put the question in a different way? may be like: 'please explain the calculation tip (talked about - above) with an example'.
Could anybody please help?