Charts and Reports

[NickL]

We just recently moved from Google to Caspio. I'm trying to find a way to recreate the same reporting we used in google and the report was created by an outside source. Right now, we are using a bar chart. I would like to do something similar to our previous reports. 

 

 

[futurist]

Hi @NickL,

You can achieve this by creating a Details DataPage and using Calculated Values to reference all the counts you need (then hiding those Calculated Vaiues so they dont show up in the DataPage the way Calculated Values do by default - I hid them using the method here: https://howto.caspio.com/tech-tips-and-articles/how-to-hide-fields-in-datapages/), creating HTML elements that look like those panels that you want to have, then referencing the Calculated Values inside those panels.

For example, this is how I would make the calculations to reference the count:
SELECT Count(Record_ID) FROM Overview_Table WHERE Category = 'Odor & Detail Combo'

I would do the same for the other counts I need. And then hide them as indicated here: https://howto.caspio.com/tech-tips-and-articles/how-to-hide-fields-in-datapages/, and then creating the HTML elements for the panels, so something like:

 

<div class="maindiv">

<div class="divcounter">
<span>Odor & Detail Combo</span>
<span>[@calcfield:1#]</span>
</div>

<div class="divcounter">
<span>Standard Odor Treatment</span>
<span>[@calcfield:2#]</span>
</div>

</div>

 

As for the styling of the panels, your CSS (placed in the header) would look something like this:

<style>

.maindiv{
display: flex !important;
}

.divcounter{
margin: 20px;
border: 1px solid black;
    display: grid;
    text-align: center;
    padding: 20px 50px;
}

.divcounter span:nth-child(2){
font-weight: 600;
font-size: 20px;
}
</style>

[NickL]

Hi @futurist

thank you so much responding to this post.  this is working out great for me. am i able to replace my chart with this? just like how is showing on the picture above. i want to be able to see this above my reporting. can this be done using the Combined Chart and Report?

[Tubby]

@futurist kudos to this brilliant solution!

@NickL Instead of combined chart and report, since there is no chart type available for this type of overview-like aggregations, perhaps you can just use a simple tabular report? Then all those code, I believe, can be put inside the Header so it shows up on top. I have not tested it yet but I think it would. The only problem is, you'll be making the calculations using a Calculated field in the table and it will require a different way to hide columns in the report to hide those calculations: 

 

[futurist]

19 hours ago, NickL said:

Hi @futurist

thank you so much responding to this post.  this is working out great for me. am i able to replace my chart with this? just like how is showing on the picture above. i want to be able to see this above my reporting. can this be done using the Combined Chart and Report?

Hi @NickL,

 

maybe you could just embed the DataPage on a chart so that it appears at the top?