Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

Can you create a stacked chart with two data values in same field e.g. Feild1 =5,6

Can you create a stacked chart with two data values in same field e.g. Feild1 =5,6
So I want to create a stacked chart with each field as the catagory name and the two stacked values being e.g. 5 and 6?
Can it be done?
0
bruskhickory
Asked:
bruskhickory
1 Solution
 
Nico BontenbalCommented:
I think the answer liija gives you to this question is the best option to solve your problem:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_28013323.html
0
 
liijaCommented:
In your case, if you have fixed two digits in your column, a simple query might be enough:

SELECT
SUBSTRING(Field1, 1,CHARINDEX(',', Field1)-1) AS Decimal1,
SUBSTRING(Field1, CHARINDEX(',', Field1)+1, LEN(Field1)) AS  Decimal2
FROM YourTable

If you have more complexity, like varying quantity of digits in your column, you'll need some more logic.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now