Good morning
I have a relational report that uses a Line Visualization (az.Line).
I have
- Week# as Category
- Year# as Series
- TotalQty as Measure
I've been asked to add an additional field to the tooltips so it shows what the start date and end date for the Week# are.
As final result, I should be displaying in the tooltip
- Week# = 1
- Year# = 2017
- Date = From 20170101 to 20170107
- TotalQty = 123456
I modified the visualization to include a nest section:
<slots>
<categorySlot name='categories' categoryValues='indexedFull' >
<label ids="lblCategories"/>
<tooltip ids="tooltipCategories"/>
</categorySlot>
<categorySlot name='series' categoryValues='indexedFull' >
<label ids="lblSeries"/>
<tooltip ids="tooltipSeries"/>
</categorySlot>
<categorySlot name='tooltips' categoryValues='indexedFull' >
<label ids="lblTooltips"/>
<tooltip ids="tooltipTooltips"/>
</categorySlot>
<valueSlot name='size' supportsRange='true' >
<label ids="lblSize"/>
<tooltip ids="tooltipSize"/>
</valueSlot>
</slots>
<dataSets>
<dataSet name='dataSet' hasChartElements='false' optionalOverride='false'>
<label ids="lblDataSet"/>
<tooltip ids="tooltipDataSet"/>
<categoryAxes>
<categoryAxis name='categoriesEdge'>
<axisStructure>
<nest>
<set refSlot='categories'/>
<set refSlot='tooltips'/>
</nest>
</axisStructure>
</categoryAxis>
<categoryAxis name='seriesEdge'>
<axisStructure>
<set refSlot='series'/>
</axisStructure>
</categoryAxis>
</categoryAxes>
<valueAxis>
<valueAxisSet>
<valueAxisValue refSlot='size'/>
</valueAxisSet>
</valueAxis>
</dataSet>
</dataSets>
I've also modified the json file accordingly
[
{
"id":"dataSet",
"fields":
[
{
"id":"categories",
"label":"abc",
"categories":
[
"abc",
"abc",
"abc",
"abc",
"abc"
]
},
{
"id":"series",
"label":"abc",
"categories":
[
"abc",
"abc",
"abc"
]
},
{
"id":"tooltips",
"label":"abc",
"categories":
[
"abc",
"abc",
"abc",
"abc",
"abc"
]
},
{
"id":"size",
"label":"abc"
}
],
"rows":
[
[
0,
0,
0,
60
],
However, I don't get the results I want when executing the report:
After I add the new field under "Tooltips"
- If aggregation is default, the chart renders completely blank
- If aggregation is None, I get the tooltip I want but all I see are points with no line connection
When I look at tabular data in the query I do see the expected results
Do you guys have any idea what I'm missing?
Thanks in advance!