This examples demonstrates the difference between values collected in a single row (see the described issue) and having values assigned as individuals (known as separate entities, see the solution). Values representing the same knowledge (meaning containing the same value assignments) are only represented once per subject (see Aggregating numbers and Incorrect Sum if more than one property has same numerical value).
bubble chart, subobject query, number aggregation
Issue[edit]
I am trying to use d3chart for displaying data prepared with subobject definitions:
{{#subobject:progress|progress month=2011-11|progress count=372}} {{#subobject:progress|progress month=2011-12|progress count=809}} {{#subobject:progress|progress month=2012-01|progress count=616}} {{#subobject:progress|progress month=2012-02|progress count=588}} {{#subobject:progress|progress month=2012-03|progress count=579}} {{#subobject:progress|progress month=2012-04|progress count=841}}
The query is:
{{#ask: [[progress month::+]] |?progress month |?progress count |mainlabel=- }}
Progress month | Progress count |
---|---|
2011-11 2011-12 2012-01 2012-02 2012-03 2012-04 | 372 809 616 588 579 841 |
If displaying it with format d3chart
{{#ask: [[progress month::+]] |?progress month |?progress count |mainlabel=- |format=d3chart |charttype=bubble }}
the result is:
Loading...
But that is not what I had expected. How would i get the true distribution? of data on progress month?
Solution[edit]
Subobjects need to be unnamed with -[edit]
{{#subobject:-|progress month fix=2011-11|progress count=372}} {{#subobject:-|progress month fix=2011-12|progress count=809}} {{#subobject:-|progress month fix=2012-01|progress count=616}} {{#subobject:-|progress month fix=2012-02|progress count=588}} {{#subobject:-|progress month fix=2012-03|progress count=579}} {{#subobject:-|progress month fix=2012-04|progress count=841}}
Tabular query[edit]
{{#ask: [[progress month fix::+]] |?progress month fix |?progress count |mainlabel=- }}
Progress month fix | Progress count |
---|---|
2011-11 | 372 |
2012-02 | 588 |
2012-03 | 579 |
2012-01 | 616 |
2011-12 | 809 |
2012-04 | 841 |
Chart query[edit]
{{#ask: [[progress month fix::+]] |?progress month fix |?progress count |mainlabel=- |format=d3chart |charttype=bubble }}
Loading...