Hi,
I run a search along the lines of:
| dbxquery query="exec sp_executesql
N'/* SELECT QUERY HERE
connection="topas" | chart sum(Perc)
as Percent over Task
The above outputs a very nice chart listing each taskname down the y axis and the percentages on x however when i export to a dashboard or run the same search when creating a dashboard I lost the y-axis values. I can hover over the bars on the chart and it will display the value however I need them to be displayed on the y-axis as they do in my search output.
Any advice on how to go about this would be greatly appreciated!
Just needed to expand the window containing the chart and the y-axis scale values appeared!