I’ve a real use case on a flexmonster table where I have several rows with several columns ([Measures]).
Some of this rows (present in the dataset) are hidden on screen. It is all rows with “empty value” (or no value at all) for ALL the columns measured.
Here an example :
The line “Toronto” has an empty “Quantity” value.
The line “Toronto2” has no column key “Quantity”.
As long as “Price” measure is displayed, we will see Toronto and Toronto2, with an empty cell for Quantity column.
But if I hide the “Price” measure (right click, “hide measure”), both “Toronto” and “Toronto2” lines are not displayed anymore, even if there are present in the datasource AND also in the “city filter”.
Is it an issue ? Or is there any “options” that let me display these kind of lines ?
Thank you for reaching out to us.
Rows representing members “Toronto” and “Toronto2” are displayed until there is at least one not empty measure associated with them. In the example you have provided, the measure named “Price” is defined for “Toronto” and “Toronto2”, whereas the measure named “Quantity” is defined and not empty only for “Los Angeles”. That is why the component hides unused rows if you are hiding the “Price” measure.
You are welcome to contact us in case of additional questions.
Is there any option to display these “unused” rows ?
Because for example if we have several measures (price/VAT/…) with only one measure filled and all others not, this row won’t be considered as unused.
In our real use cases sometimes we have to display these unused rows to let the end user see “used rows” (with data) and those without (which is important for the end user and hiding them is to hard to distinguish if there are hundreds of lines).
Is there any option to display these “unused” rows ? (very important feature for us)
Thank you for your feedback.
Your suggestion sounds reasonable; the described option will be provided with the minor update ETA Jan 13.
Our team will inform you when the version with a fix will be available to download.
Please, contact us in case of additional questions.
We are glad to announce that the option grid.showEmptyValues to show members with empty values on the grid was added.
This is available in the 2.7.23 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please contact us in case any questions arise.