molgenis / molgenis-emx2

MOLGENIS EMX2, the latest version of the MOLGENIS data platform.
GNU Lesser General Public License v3.0
11 stars 16 forks source link

Incorrect number of samples for fact table rows when "Split by" is not enabled on all dimensions #3969

Open sasurfer opened 3 days ago

sasurfer commented 3 days ago

Before you submit a new issue, please take a moment to check if it hasn't already been reported. This helps us streamline our efforts and ensures that your concern is addressed efficiently.

How to Check for Existing Issues

Search: Use the GitHub search bar to look for keywords related to your issue. This includes error messages, feature names, or any relevant terms.

Issues Section: Navigate to the "Issues" tab on our GitHub repository to see a list of reported problems and feature requests. Filter through open and closed issues to find similar cases.

What version of EMX2 are you using (see footer) v10.86.0, v10.88.2

Describe the bug In the fact table the number of samples is not correct when I disable at least one of "Split by" boxes.

To Reproduce Steps to reproduce the behavior:

  1. Go to 'https://directory-emx2-acc.molgenis.net/ERIC/directory/#/collection/bbmri-eric:ID:EXT_76823:collection:MainCollection?search=76823'
  2. Select Urine from first column, Male for second one, Middle-aged for third one
  3. Sum manually the samples. That is 3. This is correct and consistent with the saved fact table csv file.
  4. Now Uncheck "Split" by for "Disease codes" column.
  5. Select again Urine- Male- Middle-aged. The number of samples yielded is 1. It should be 3.

Expected behavior Unregardingly of any Split by box unchecking the number of samples should be the correct one. Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

Smartphone (please complete the following information):

Additional context Add any other context about the problem here.