FROM Dovico.dbo.PLTC PLTC
AND GetDate ())
GROUP BY PLTC.Classification, PLTC.[Week Ending]
ORDER BY PLTC.[Week Ending] ASC, PLTC.Classification ASC
I am trying to create an automated line chart in TDA to display the last twelve weeks of HoursLogged by Classification [Absence, BAU, Project].
My SQL script (copied below) collects the correct dataset. However I can not find out how to configure the Primary Axis X in the Chart Wizard to display as a ‘percentage of row’.
The same as you can in MS Excel ‘Value Field Settings’ (see attached image)
SELECT PLTC.Classification,SUM (PLTC.[Hours Logged]) AS TotalHoursLoggedWHERE ([PLTC].[Week Ending] BETWEEN dateadd (wk, -12, GetDate ())
I have been through the chart wizard documents on the devExpress website, but could not find the answer.
Any help you can offer would be welcome.
Thank you in advance.