How to create a statistic dashboard ? Topic is solved

[yvesf]

yes exactly,
I am at this stage, blocked by this unique request supporting a form. I see in your example that we can do that. How do you perform that ? I am impressed.

run iframe.PNG

[kev1n]

First, I created two Browse Forms, one for the daily and one for the monthly turnaround.
Next, I created a Launch form called "Dashboard" and placed two run (iframe) objects on that form.

I used the initial SQL dump file you provided and I have attached the updated dump containing the dashboard.

fact.zip

[yvesf]

wonderfull, you have to create browse form first, the number you want and that's it. Sorry for not having taken the ball before.
Thx again for your precious help. Browser form wasn't part of my learning path, it is now.
Yves

[yvesf]

I have now a dashboard presenting turn-over per day, per month and per year.
Is it possible to do the same beetween 2 dates defined by the end-user. Is it possible to leverage the same approach (browse form) ? How Can you pass the dates as parameter of the browse SQL request ?

[kev1n]

Add two text objects of Type Date to the form, where users can enter dates.
Add a button to the Launch form: This button will trigger the filtering when clicked.

Add two text objects of Type Date and a button to the Launch form.

Add an onclick event to the button: This step involves attaching a JavaScript event handler to the button's onclick event. When the button is clicked, the code specified in the event handler will be executed.

Code: Select all

var f = $("#id_of_your_browse_iframe_here")[0].contentWindow;
f.nuSetProperty('date_start', $('#id_of_date_start').val().nuRemoveFormatting());
f.nuSetProperty('date_end', $('#id_of_date_end').val().nuRemoveFormatting());
f.nuGetBreadcrumb();

In the Browse SQL, add a WHERE clause:

Code: Select all

WHERE (date_start_column BETWEEN #date_start# AND #date_end# OR '#date_start#' like '#%')