Question

Tabular data - creating table based on count.

  • 11 September 2019
  • 1 reply
  • 4 views
P
Badge +1

I have a dataset where features contain two attributes - Month and Provider. What I want to do is create a table wherein the Months of Feb to Aug inclusive run along one axis, Provider along the other and the cell contents are a count of occurrences of features per Provider in each month.

I've achieved this using a fairly roundabout method - which was ok given that the range of variables was fairly small; however, I can't help but feel that there is a simpler way, presumably using StatisticsCalculator or AttributePivoter...?

 

1 reply

ebygomm
Rank
Userlevel 1
Badge +10

This answer might help

https://knowledge.safe.com/questions/47095/aggregate-and-rearrange-tabular-data.html

You can create an attribute which is named after the value (in this case month) then aggregate the data grouping by provider name and merging the attributes. You will need to manually expose the months for them to appear

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.