Need a special offer?Find out if your project fits.
+

How to show row with empty columns values

Answered
Patrick TAVARIS asked on December 5, 2019

Hi,
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 :
https://jsfiddle.net/euryhnmq/1/
 
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 ?
 
 
 
Regards
 
Luc Bonnin

15 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 5, 2019

Hello, Patrick,
 
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.
 
Best Regards,
Illia

Public
Patrick TAVARIS December 5, 2019

Hi Illia,
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)

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 6, 2019

Hello,
 
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.
 
Regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 14, 2020

Hello, Patrick,
 
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.
 
Best regards,
Illia

Public
Patrick TAVARIS February 26, 2020

Hi,
We have upgraded from 2.7.23 to 2.8.0.2 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 :

  • I can confirm that the json transmitted to the js contains all rows
  • the flexmonster table doesn't show a lot of rows (even rows that are not empty.)
  • our use case is a row of site name with column containing a measure (number) and a date (in string). So 3 columns only used
  • Absolutely no filtered data (i can see the complete list of sites (my col1) in the report filter but site are not displayed in the table

 
Some hypothesis :

  • row that contain our "measure" (number) with some negative value are hidden (which is not intended to be hidden by your js)
  • maybe a larger issue your side regarding row with data only for some column (date) and not on all columns.

 
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.
 
Regards
 
Luc Bonnin

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster February 27, 2020

Hello, Luc,
 
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.
 
Best regards,
Illia

Public
Scott Oliver May 19, 2020

Hi Illia,
 
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.

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 19, 2020

Hi Scott,
 
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!
 
Kind regards,
Mykhailo

Public
Scott Oliver May 19, 2020

Hi Mykhailo,
 
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.

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 21, 2020

Hi Scott,
 
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.
 
Regards,
Mykhailo

Public
Scott Oliver May 22, 2020

Hi Mykhailo,
 
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.

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 22, 2020

Hi Scott,
 
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.
 
Kind regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster June 16, 2020

Hi Scott,
 
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.
 
Best regards,
Mykhailo

Public
Scott Oliver June 17, 2020

Hi Mykhailo,
 
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"]?

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster June 18, 2020

Hi Scott,
 
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.
 
Regards,
Mykhailo

Please login or Register to Submit Answer