http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help Tag: sqlserver en Sat, 11 Sep 2010 02:43:47 +0000 http://dashboard.infocaptor.com/topic/inventory-balance-trend-in-ms-sql#post-31 Fri, 26 Dec 2008 17:04:30 +0000 admin 31@http://dashboard.infocaptor.com/ <p>email reply--</p> <p>Thank you and happy holidays</p> <p>As I understand, you have a SQL query that returns the current inventory balance from the database.</p> <p>Does your table have any kind of date column? For e.g If you are sql query is like<br /> select sum(inventory_balance)<br /> from inventory_transactions</p> <p>then is there any other time related column in the inventory_transactions table? If there is then you could apply database functions to get the week part from the date for e.g</p> <p>select format(trx_date,'MMM') as period, sum(inventory_balance)<br /> from inventory_transactions<br /> group by format(trx_date,'MMM')</p> <p>You could then put this query in the chart editor and select a bar chart type.</p> <p>If you don't have any time related columns in your table then you would need some mechanism to capture that information or store the weekly snapshot in a seperate table and use that table for your chart. </p> http://dashboard.infocaptor.com/topic/inventory-balance-trend-in-ms-sql#post-30 Fri, 26 Dec 2008 17:03:29 +0000 admin 30@http://dashboard.infocaptor.com/ <p>Happy Holidays...<br /> I have downloaded InfoCaptor, and it is exactly what I am looking for! thank you!<br /> quick question....<br /> I plan on using it to access MS SQL databases.</p> <p>How do you track items that do not have datebase fields.<br /> For example, I have a SQL query that looks at our inventory balance when the SQL statement is run. How would I track the results on let's say a weekly basis with a chart? TheSQL statement result is point in time. Where are the results stored so that I can monitor a trend? </p>