Hi Experts ,  Is there any way we can have different colors on Bar chart based on X-Axis values , below is code to my bar chart, i want to have different color bars for different countries (X-Axis values). <search base="base_search"> <query>|search Country=$Country$|stats dc(conversation-id) by Country</query> </search> <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option> <option name="charting.axisTitleX.visibility">visible</option> <option name="charting.axisTitleY.visibility">visible</option> <option name="charting.axisTitleY2.visibility">visible</option> <option name="charting.axisY.abbreviation">auto</option> <option name="charting.axisY.minimumNumber">1</option> <option name="charting.axisY.scale">log</option> <option name="charting.axisY2.abbreviation">auto</option> <option name="charting.axisY2.enabled">1</option> <option name="charting.axisY2.scale">log</option> <option name="charting.chart">column</option> <option name="charting.chart.overlayFields">count</option> <option name="charting.chart.showDataLabels">all</option> <option name="charting.chart.sliceCollapsingThreshold">0.01</option> <option name="charting.drilldown">none</option> <option name="charting.fieldColors">{"CD";10": 0xFF0000, "IND": 0xFF9900, "ZA":0x008000}</option> <option name="charting.legend.placement">right</option> <option name="refresh.display">progressbar</option> <option name="trellis.enabled">0</option> <option name="trellis.size">large</option> <option name="trellis.splitBy">Country</option> </chart>     ... View more

Hi Experts,  While adding below query to my dashboard i am getting error saying     |eval Category=case (Ratings>"8","Promoter",Ratings > "7","Detractor",Ratings > "6" AND Ratings < "9", "Passive") Error: Unencoded <   Regards Mayank   ... View more

Dear experts ,  I am searching on my bot index, which contain conve-id and rest of the fields are stored as payload. Using spath i am able to extract required fields from payload into a table , now for trend analysis i want to use time chart command to see number of users per month , however its not working , below is the query for your reference , need help with the query : index=idx_chatbot logpoint=response-in AND service="journeyService" OR service="watsonPostMessage" |spath input=payload output=displayname path=context.displayName | spath input=payload output=Country path=context.countryCode | spath input=payload output=Intent path=intents{}.intent |spath input=payload output=ticketResponse path=response.createTicketResponse.Message | table conversation-id timestamp service duration logpoint userFeedback displayname text Country Intent category ticketResponse payload | dedup conversation-id | timechart span=1mon count(displayName) ... View more