Create pivot table from a collection

Ask the community
,
1

Hi,
My collection has a date and an amount.
D1 $100
D2 $150
…
Is there a way I can display this in the following way
Month1 $250
Month2 $350
…
Is there a way I can create a pivot table from my collection data
OR
Is there a way to select the data and then do some calculations and then display onto a dashboard style interface ?

2

There are a few ways to do this. One way is to use an afterQuery data hook . In the hook code you can use standard JavaScript date functions to extract the month from the date field and use the month as the date value instead.

3

I though the question was how you create a “list” with more than one row showed. I am creating a list of classmates from high school class and want a whole page with a list of names, photos etc. Like in a table or list. I tried the list, but didn’t see the data link as an option and not sure how to get it to fill a page with similar rows. Got my next button to work but that is showing just one at a time.

4

Hi Sandy,
can you share a bit more info on your page design?
it should be easily doable, but I need some more info to give some guidelines.

thanks.

5

Hi Sam,
I do not want to just extract the month from the date field. I would like to add all the amount fields for a particular month and show the consolidated amount against a month.
Example - The collection data is as follows:
01-Jan-17 $100
02-Jan-17 $200
01-Feb-17 $300
02-Feb-17 $400

I would like to display the following on my page:
Jan-17 $300 … (Adding $100 and $200)
Feb-17 $700 … (Adding $300 and $400)

Thank you.