How to create a statistic dashboard ? Topic is solved

[yvesf]

Hello,

I have an invoice form in which I have a list of invoice as following :
- date, product Name, quantity, Unit Price, Total price.

I would like to have a dashboard presenting the turnover per day, per month, per year.
I don't know how to perform that.
If anyone has got an example of that kind of stats ...
Many thanks and regards,

Yves

[kev1n]

Hi,

You can use embedded Browse forms (object Type "Run", Method "iFrame")

This topic could be helpful:
viewtopic.php?t=12023

To calculate the turnover:

https://sharegpt.com/c/sCOxaiZ

[yvesf]

Hello Kev1n,

If I use a run object as proposed, it will work with the request defined in the browse form. In fact we have only one sql request (the one behind the browse form).

Capture.PNG

with the related request on the form

Capture1.PNG

I would like to have several requests for one related form. How can we do that ? One for the day, one for the month, one for the year.
Will it be possible to do that ? Do you have an example ?
Many thanks anyway for your help,

Yves

[yvesf]

Hello,

I have attached a simple database for this exercice in which I would like to have stats per week, month and year.
database -->

06-05-2023_111336_647dd1701ca4b_nuBuilder_backup.sql.gzip

Please could you help me to create this dashboard.
Many thanks,

Yves

[kev1n]

Should they be created on a separate form? And is your struggle related to creating the objects or creating the SQL?

[yvesf]

The requests are applicable on only one specific form. My understanding is that you cannot have multiple requests on only 1 form.
From the same form 'invoice', I would like to retrieve the turnover per day, per week, per month and per year and representing that on a dashboard in the application.
The sql requests aren't my main problem here - maybe it will be, I am not there - : it is more the fact that we cannot have on a same form 3 different SQL requests. It is more a design pb : what is the best way to make some stats (several sql requests on the same table) based on one form and represents the result in nuBuilder.
Many thanks for your help.

Yves

[kev1n]

Use a launch form and place on it as many run (iframe) objects as you want?

[yvesf]

Is it possible to have several SQL requests on the same form via run(iframe) ? My understanding is that we have only 1 request per form (browse tab). Am I wrong ?

Capture.PNG

[kev1n]

You can have as many as you want

[yvesf]

Do you mean with run(iframe) based on report and not based on form ?