I have a combo chart in which I wish to show Month Dates as dimension and Temperature Value as Trendline, with bars of red, green, amber as bars of defined height based on values changing per day. This part is achieved.
Challenge:
I want to add same trend line to be added but one trend line for each city, (I have the city dimension) as well the CityTemp as the value for trend line.
When Am adding Date & City in the dimension, and CityTemp Trend line as the Line expression only, it works fine(Showing 5 diff lines for 5 cities, with diff colors), but when I add other TrendLine (AvgTemp), the chart gets disturbed with, showing only Two lines
One for CityTemp (Showing all 5 citites together in one line)
And other Line Showing the other AvgTemp.
Why is it so ?
How can I add more than one line in combo chart, and want that one line to be multicolored showing separate line for the dimension values.
Thanks,
Swapneel
