What I am trying to achieve is that I have a row in my DB that has different costs (Labor_costs, Material_Costs, equipment_costs) associated with a project.
What I want to be able to do is have a ring chart that shows the project name but each segment of the ring shows the different costs.
I did find a way to do it but I had to rearrange the way the data was presented.
Currently my data is in a single row
Project_Name| labor_cost | Material_cost | Equipment_cost |
project A 100 200 1000
project B 300 400 2000
project C 500 600 3000
I quickly created an excel and repeated the project name and added 2 additional columns - one with the name of the cost and another with the value.
PROJECT_NAME | COST_TYPE | COST |
project A Labor 100
project A Material 200
project A Equipment 1000
and so forth
This of course worked and gave me what I want.
So my question is - How can I rearrange my data structure so that I can fulfill the graph requirements.
Many thanks in advance
MKThis message has been edited. Last edited by: MAK,
O/S Windows 7
There is several ways to do it, here one to have it in a new data source (create rows with columns)
TABLE FILE CAR SUM RETAIL_COST/P8 AS 'MEAS' BY COUNTRY BY TOTAL COMPUTE TITLE /A10 = 'RETAIL'; ON TABLE HOLD AS RETDATA END -RUN TABLE FILE CAR SUM DEALER_COST/P8 AS 'MEAS' BY COUNTRY BY TOTAL COMPUTE TITLE /A10 = 'DEALER'; ON TABLE HOLD AS DEALDATA END -RUN TABLE FILE CAR SUM SEATS/P8 AS 'MEAS' BY COUNTRY BY TOTAL COMPUTE TITLE /A10 = 'SEATS'; ON TABLE HOLD AS SEATDATA END -RUN TABLE FILE RETDATA SUM MEAS BY COUNTRY BY TITLE ON TABLE HOLD AS WHOLEDATA MORE FILE DEALDATA MORE FILE SEATDATA END -RUN TABLE FILE WHOLEDATA SUM MEAS BY COUNTRY BY TITLE END -RUN
Always use the code tag when posting sample data and/or code
It's the last one on the ribbon that looks like the below
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
Thanks MartinY. That approach worked perfectly.
O/S Windows 7
|Powered by Social Strata|