Jump to content
  • 0

Is there a Big Number type of Report?


tbunch

Question

GOAL:  I'm looking for a way to publish a single (SUM) number in an embed.  

CONTEXT:
We are running a live event next month (and a couple through the end of the year), I have a parameterized form that collects pledges or committments.  So I have a record that has a `campaign` and `total_amount`. 
On the same page - I would like to publish a large number that reflects the SUM of the `total_amount` with a parameterized filter on the campaign.  I have it working on the tabular reports (and a version of pie charts), but haven't sorted out how to do it as a single large currency value without including the details below?

Any hints or examples out there?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 1

Hello, have you tried craeting  a Details DataPage then just use one field to be displayed on that DataPage. Then, you can change the form element of that field as a calculated value and paste the formula that you are using  in your tabular Report to display only a single (SUM) value. Just like the example image below:

screenshot-www.invest_xbtc_co.za-2021_06.12-10_30_27.png.1b8ab869015c206a6c1fb15b1ac89c26.png

Link to comment
Share on other sites

  • 0

@NailDyanC  - Yes... I did look into it, perhaps I should have been more articulate in that I am attempting to use Aggregate Functions.

So if I have www.pledge.org?utm_campaign="help"  to capture the correct campaign into a pledge record.

Then I effectively want www.pledge.org/results?utm_campaign="help" to pull an aggregated sum of all of the pledge values.

SELECT campaign, SUM(amount)
FROM PLEDGE
WHERE campaign = 'help'
GROUP BY campaign

It appears that I can only run Aggregate calculations on search and report pages (https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/).  It works as a report but the formatting is nothing like what you have pulled off above (and I haven't found a way to run the SUM/Aggregate in Details Page).

image.png.87085c7680d1c1d122bb17e890487285.png

Link to comment
Share on other sites

  • 0

Hi @tbunch,

You can use SQL Calculations on Details DataPage by adding a Calculated Field or a Virtual Field set to Calculated Value

image.png


After setting up the totals, you can edit the look of the details page using CSS code in the Header.  I highly recommend requesting a free app template from Caspio's Marketplace and checking out the setup. For example, the "Online Training Management Software" has a similar workflow to what you have described: https://marketplace.caspio.com/details/training-management/

image.png

Regards,
SP

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.

Guest
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.

Loading...
×
×
  • Create New...