Home Analytics

When using the Chart widget- Sorting

Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
edited November 2016 in Analytics

Using the Chart widget, the chart produced creates the group by in the order of work items. 
Management wants the support tiers to always be in alphabetic order. Has anyone been able to accomplish this?

Best Answers

Answers

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    I was attempting to use the SQL chart widgets, but ran into a functional issue the when using the option "display selected item details" I would get the details but when clicking on a specific row it would open the search page. 
    I had opened a ticket with support and was provided a fix of wi.WorkItemId as [Id] now I am getting the behavior needed for management. 
    Also learned the code I attempted 
    wi.WorkItemId as [ID] will not work. 
    Now if the Date columns can get fixed my management would be happy. 
  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    @Brian_Wiest
    What do you need fixed with the Date Columns?
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    See Cireson ticket IR58434
    Summary All Date Columns using the saved searchs or SQL widgets display as YYYY-MM-DDT00:00:00:000Z

    Now that I have the row click working as needed attempted to use convert but the widget would not accept the query
    CONVERT(varchar,DATEADD(hh,-5,[Created]),100) [Created],
    CONVERT(varchar,DATEADD(hh,-5,[Last Modified]),100) [Last Modified],
    And the above still doesn't account for Daylight savings. 
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    Well sometimes it takes two tries. Changed to location of the convert statement is the query and it is working now.
  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    Great, nice one.
Sign In or Register to comment.