We are trying to publish a change schedule on WebDesk, so that all of the analysts can see changes which are scheduled, grouped by week.
However, we have come across a limitation (confirmed by LANDesk) whereby grouped queries in WebAccess DO work, but not if the grouping is based on a range.
Basically, we have created a query in Console, which shows changes in the past 7 days and in the next 6 weeks - to displayed grouped by week. This displays fine in Console, and returns the desired results - whereby you can expand the week to view relevant changes:
However, when you add this query to a dashboard in WebDesk, it doesn't group the items - it lists them separately, which is far from ideal:
We have even tried creating a dashboard in Console and publishing it to WebDesk - but it doesn't solve the issue.
It has been suggested that we could perhaps use a calculation to sort the attribute by (calculation based on string attribute) - is there anyone who can provide any detail or information on how we can achieve this, as we are very new to calculations? There is a field on the Change window called Target Implementation Date (in date format) which we want to sort and group the results by.
Thanks in advance!