Custom visualization to add additional value in tooltip (rave1)

[rteruyas]

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:

Code Select Expand


<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

Code Select Expand


[
      {
         "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!