Toad World® Forums

Chart Wizard - Primary Axis Set to Percentage for SumHoursLogged Value

PLTC.[Week Ending],

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.

http://tda.inside.quest.com/post!default.jspa#InterfaceElementsWin/CustomDocument4161

Any help you can offer would be welcome.

Thank you in advance.

David

MS_Excel_Value_Field_Settings.jpeg

David,

We can see that your recent 3 posts regarding data report and chart are all in the same area. Is that possible to send us the table DDLs and queries you used so that we can easily reproduce the issue you experienced?

Thanks.

MY REPLY TO DIRECT EMAIL RECEIVED FROM {TDA} on behalf of {YAKE LI}

Hello,

How do I export table DDLs from within TDA?

My raw input data is received in Excel file format (from a Third party hosted system), which I have imported into a local MS SQL Server database on my desktop PC.

Do you just want the Create Table Scripts and my SQL scripts?

Is your email address (above) a secure single user or group access mailbox?

I would prefer to communicate securely when transferring company confidential data.

Would it be better to create a Quest support call ID and attached these files?

Regards

David

If you point to the table in the object explorer and go to the script tab you should get the DDL for the table. Send this with your scripts to my email dpeabody@quest.com. You can open a support case if you want but it will be directed to me.

Debbie

Thanks for the ddl and sample data. I am still a bit confused on what you want to do. The % of row that you show from Excel is used in Pivot Grids. We also have that display option as part of Pivot Grid. See screenshot. I am not sure how to apply this concept to a graph. Can you give more detail on what your end result needs to look like?

Debbie