Skip to main content
Nintex Community Menu Bar

Pulling \Count\" into a table"

  • Dec 8, 2017 11:48 AM UTC
  • 2 replies
  • 20 views
  • Translate All

Forum|alt.badge.img+9

I have a list with many items which has a column that captures the month/year. I have turned on the count totals to show how many items there is per month, but what I want to do is  put this count number into a column or table/chart so I can see something like the below. These will be used as metrics.

MonthCount (no of items)
Jan26
Feb30
March68
April32
May 58

2 replies

Forum|alt.badge.img+8
  • Dec 8, 2017 1:00 PM UTC

If you have month as a column name you can create a view the groups by month and then select "Count" on the month column in the Totals section of the view creation screen.

Translate

Forum|alt.badge.img+9
  • Author
  • Rookie
  • Dec 8, 2017 1:26 PM UTC

Hi Roger

Thanks

What I want to do is calculations with the monthly counts. ie what % more/less did we get. So I need to put the counts in a column, but not sure how to do this. Any ideas.

Translate