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.
We have upgraded from 2.7.23 to 22.214.171.124 and we discovered a huge issue on our dataset in production.
I can’t isolate a clear use case for you but rolling back the flexmonster react js fixed the issue (without touching a single line of code on our backend).
A bit of data :
Some hypothesis :
I hope you will be able to identify our use case and fix it. Please get back to me if you can’t reproduce it and when we will have more available time, we will try to help you with a use case.
Thank you for contacting us.
It would be useful for our investigation is you could provide us with some additional information about the problem you are facing. The sample report and the sample data where the issue is reproducible would also be an appropriate variant.
Please refer to the JSFiddle we created trying to reproduce the problem. The data set from the example is constructed using the description you have provided us with. It would also be really helpful if you could modify the JSFiddle in the way the issue is reproducible and share it with us.
We are looking forward to hearing from you.
We are also interested in something very similar. I have tried applying the show empty values attribute and unfortunately, in our situation this provides a lot of unwanted data.
I have attached a screenshot of our current table. The end goal is to simply provide rows for the dates which have null values (January through to December). However, although included in our JSON dataset with empty values, FM is filtering these out, jumping from April to July.
I have developed a work around by replacing the null value with a zero value, however due to other demands, that doesn’t work for us.
To provide greater detail, when applying your empty value attribute to the grid, this displays a number of additional columns, where as we are only looking to find our hidden rows.
Thank you for writing to us, we would be happy to assist you here.
So far, we haven’t managed to reproduce the described behavior. It would help us greatly with our investigation if you could provide a sample report with a dummy data set with which this is reproducible.
Alternatively, it would also be helpful if you could modify this JSFiddle sample in a way that replicates the mentioned behavior and send it back to us.
Thank you in advance and looking forward to hearing from you!
Thanks for taking the time to help out, please find the below fiddle:
You will notice that I am receiving a blank column. The hope here is that the columns are to be unaffected by the show empty values attribute, so the blank columns do not come through. We do however require the rows to behave as the current fiddle, rather than our previous screenshot.
Thank you for your swift response!
The thing with the
showEmptyValues option is that once it is set to true, both columns and rows display the members with empty values. At the moment, Flexmonster does not provide the option to show empty values for columns or rows separately.
As a workaround, we would suggest hiding the
(blank) member by filtering the “Category” hierarchy. However, while building a sample for this approach, we’ve realized there is an issue with member filtering not working properly when
showEmptyValues is enabled. We are going to investigate this further and provide a fix with our upcoming minor release ETA Jun 15th.
Do you think this approach with filtering would work for you?
Looking forward to your reply.
Yes, that would be one step closer, I appreciate the help.
Obviously a row or column empty values attribute would be better, but I can understand that this may not be high on the list of priorities.
It is great to hear that this approach would work for you. We will make sure to keep you updated oh this matter and we will reach out to you as soon as the fix is ready.
Feel free to reach out to us if you have any other questions we can help you with in the meantime.
We are pleased to inform you that the issue with filtering when
showEmptyValues is enabled was fixed.
However, while investigating this issue we’ve also realized it is indeed possible to implement a separate
showEmptyValues option for rows and columns. Therefore,
showEmptyValues now accepts string values (“rows” or “columns”) as well, allowing you to display empty values separately for rows or columns.
Check out the following JSFiddle sample illustrating this approach: https://jsfiddle.net/flexmonster/46ajwevx/
More info on this property can be found in the updated documentation page: https://www.flexmonster.com/api/options-object/
This is available in the 2.8.9 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 let us know if everything works fine for you.
That really is exciting and appreciated, thank you to both you and your team.
At the risk of sounding like a spoilt brat, I would like to take this now one further. Unfortunately this doesn’t help us exactly, as we only want to show the empty values for the date. Rather than all three row fields. In my screen shot from the previous post, we don’t want empty values for contract number or cargo name either.
What are the chances of having this function also by field name (or array), rather than, true, false, rows or columns. You may specify “date start” or [“date start”, “date stop”]?
Thank you for writing to us.
While we understand the potential convenience of such functionality, this does not exactly align with our current roadmap, which makes it impossible for us to say whether we will be able to implement this
showEmptyValues extension in the near future.
Still, we have added your suggestion to our wishlist and we will make sure to let you know in case anything changes on this matter.
Please let us know if you have any other questions we can help you with.