Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to add multiple measure to a ring chart
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] How to add multiple measure to a ring chart
 Login/Join
 
Member
posted
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.

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

MK

This message has been edited. Last edited by: MAK,


WebFOCUS 8203M
O/S Windows 7
 
Posts: 7 | Registered: August 02, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2223 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
Thanks MartinY. That approach worked perfectly.


WebFOCUS 8203M
O/S Windows 7
 
Posts: 7 | Registered: August 02, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to add multiple measure to a ring chart

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.