Page 1 of 2

Inconsistent number of rows in Dashboard exports

Posted: Mon Jul 08, 2024 1:15 am
by LRHF
Hi there,
We created a couple of Dashboards and I'm investigating why the exporting is inconsistent. We have the "Missing Superbills" dashboard (see attached image), and all options (except Image) export the full amount of rows (2,930) which is what we expect.

On the other hand, as you can see in the "Workflow Status" attached image, the dashboard has thousand of rows, and the last item on screen is "Superbill Age (days)" 115 (highlighted). However, when exporting to:
  • Image: it exports 2 more rows than what is visible on screen.
  • Data: it exports 4 more rows than what is visible on screen.
  • Excel: it exports 3 less rows than what is visible on screen.
  • PDF: it export the exact number of rows on screen.
I had a look at the templates (JSON files) and didn't see any specific configuration about exporting, so I'm guessing this could be either a bug or something we didn't specified properly in the Designer.

Could you please let me know (if the issue is in our side) how to fix it, so that all rows are exported? Thanks,

Re: Inconsistent number of rows in Dashboard exports

Posted: Mon Jul 08, 2024 9:21 pm
by Lech Kulikowski
Hello,

We need some additional time to investigate the issue.

Thank you.
#14835

Re: Inconsistent number of rows in Dashboard exports

Posted: Mon Jul 22, 2024 12:09 am
by LRHF
Hi there,
Do you have any updates on this?

Re: Inconsistent number of rows in Dashboard exports

Posted: Mon Jul 22, 2024 2:16 pm
by Lech Kulikowski
Hello,

For now as it is, since PDF has clear page dimensions and excel does not.
However, we have taken this issue under consideration and will look for a solution.

Thank you.

Re: Inconsistent number of rows in Dashboard exports

Posted: Wed Aug 14, 2024 1:47 am
by LRHF
Hello,

I just wanted to know if there is already a timeframe for fixing these issues, or any other updates you can provide me with.

Thank you.

Re: Inconsistent number of rows in Dashboard exports

Posted: Wed Aug 14, 2024 11:02 pm
by Lech Kulikowski
Hello,

We are still working on the task.

Thank you.

Re: Inconsistent number of rows in Dashboard exports

Posted: Fri Sep 27, 2024 5:05 am
by LRHF
Hello,
Do you have any updates on this issue?
It's been a long wait... almost 3 months.

Thanks, Luis.

Re: Inconsistent number of rows in Dashboard exports

Posted: Fri Sep 27, 2024 8:49 am
by Lech Kulikowski
Hello,

We have added new options for exports. It will be available in the release 2024.4.1 within two weeks.

Thank you.

Re: Inconsistent number of rows in Dashboard exports

Posted: Fri Oct 11, 2024 5:19 am
by LRHF
Hello,
I installed 2024.4.1 but unfortunately I don't see any changes.

Just to confirm this is part of our API response:
"adapterVersion": "2024.4.1",
"handlerVersion": "2024.4.1",

The "Missing Superbill" dashboard exports 3.828 rows in the CSV file, whereas "Workflow Status" exports only 15 rows in the CSV file, 1 row less that what is shown on screen, although it has thousand of rows.

I have attached the template for you to review. Is there anything wrong that you can see in our template? I had a look and I don't see any setting that can be affecting the number of rows to be exported.

Thanks for your help, Luis.

Re: Inconsistent number of rows in Dashboard exports

Posted: Fri Oct 11, 2024 1:12 pm
by Lech Kulikowski
Hello,

If you export the entire dashboard, it only exports what is shown on the viewer.
If there is a table with 1000 records and the viewer shows 10 records, if you export the entire dashboard, only 10 records will be exported. If you need all 1000 records, you need to export only the table.

Thank you.