[SOLVED] How to add multiple measure to a ring chart
Hi all,
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.
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,
WebFOCUS 8203M O/S Windows 7
October 31, 2019, 07:26 AM
MartinY
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