Dashboard 1000 results limitation

[RAYK47]

Hello all

I am using the below SQL query to display data from a SQL view and I cannot find out how to get around the 1000 limit. There are about 4000 rows when run in the search but always limits to 1000 in the dashboard.

| dbquery "SQL Server" limit=1000000 "select [date], [%iowait], [%util]  from dbo.vwora01cpulastmonth "  | eval new_time=strftime(date, "%Y-%m-%d %H:%M")|table new_time, %iowait, %util

Any help would be appreciated as I am pulling out what little hair i still have.

[linu1988]

You are looking at one of my favorites.

Max Data on Dashbaord

Thanks

[linu1988]

as @davidpaper suggests it does the change on a global basis.

[RAYK47]

I have a work around.

Adding this line to each chart works but what I really need is a global setting.

5000

[RAYK47]

I have tried this but it makes no difference.