I need to make a dashboard in my application and I successfully implemented. The case is that I want to make three charts of three condition. The charts used is bar charts and always there will be a single bar on each chart. i will list the query below..
Chart 1 : Select 'Accounts Team Pending' as CategoryName, count( distinct LPO_NO) as ProductCount FROM [dbo].[LPOS] where TicketNumber is not null and InvoiceNumber is null
Chart 2 : Select 'GHQ Team Pending' as CategoryName, count( distinct LPO_NO) as ProductCount FROM [dbo].[LPOS] where TicketNumber is not null and InvoiceNumber is not null
Chart 3 : Select 'CSV Not Generated' as CategoryName, count( distinct LPO_NO) as ProductCount FROM [dbo].[LPOS] where TicketNumber is not null and InvoiceNumber is not null and PrintStatus is null
Can you suggest any other charts i can use for this purpose...
Go to the complete details ...