Jump to content
  • 0

Display 2 Bar Chart Report Datapages on One Datapage that triggers both charts off One Search Field




I have 2 bar charts. One is Sales by State which just counts the total records in the table by state. The other one is Sale Amount by State which is a stacked bar chart comparing Average Sale Amount vs Total Sales in each state. I want the end user to be able to submit the "date range"  for the sales one time at the top of the data page and then both charts get triggered/generated on the same datapage below the search.

Would also be nice if there was a way to pass timestamp on pageload into the end date range to load total data into each of the charts on the page load.

I have already created both of these charts and they both work, but they have separate date range searches. Hopefully someone can point me in the correct direction here. Thanks!

sales by state.png

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello @dhills,

You need to apply the approach for the dashboards.

This video can be helpful: 


The idea is the following:

1) To create a Search form that is actually a Submission form with Virtual fields.

Pass dates as parameters.

2) On the Chart DataPages use the 'Filter data based on your pre-defined criteria' option for the Search and receive dates as parameters.

3) Deploy 3 DataPages on 1 webpage.

As for the Timestamp, you may set it up like this: 

Timestamp time zone depends on the Time zone selected in Localization applied to the DataPage.



Please update this thread if you have further questions. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...