cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
charles_o Regular Visitor
Regular Visitor

Split value in column with multiple dates

 Hi-

 

New user and of course lots of questions!

 

I currently have data that looks like this-

 

Picture2.jpg

 

The fee is earned 50% on date.1 and 50% on date.2.

 

The data has to be able to graph so that it shows 50% on date.1 and 50% on date.2

 

How can I show this in the data? My first thoughts were something that looks like this below but I do not know how to manipulate into this format.

 

Example.1.jpg

 

Any help would be appreciated!

 

-C

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Split value in column with multiple dates

Open advanced editor. With your Query, go to the " Add Column" 1 tab and click "Custom Column" 2 .

 

Change the name to New Fee 3.

Enter The following Formula 4:

 

=[Fee]/2

fee.gif

 

 

Now you can delete the original column Fee.

 

Highlight both date colunms. On the Transform tab, click Unpivot Columns.

 

tttt.gif

 

It will give you two new columns, Attribute and Value. You can delete Attribute*, rename Value as Date.1/Date.2, and rename New Fee as Fee.

 

*Also, if you wanted to know if it was date 1 or date 2 then do not delete attribute!

 

2 REPLIES 2

Re: Split value in column with multiple dates

Open advanced editor. With your Query, go to the " Add Column" 1 tab and click "Custom Column" 2 .

 

Change the name to New Fee 3.

Enter The following Formula 4:

 

=[Fee]/2

fee.gif

 

 

Now you can delete the original column Fee.

 

Highlight both date colunms. On the Transform tab, click Unpivot Columns.

 

tttt.gif

 

It will give you two new columns, Attribute and Value. You can delete Attribute*, rename Value as Date.1/Date.2, and rename New Fee as Fee.

 

*Also, if you wanted to know if it was date 1 or date 2 then do not delete attribute!

 

charles_o Regular Visitor
Regular Visitor

Re: Split value in column with multiple dates

Thanks! Glad to see an active community here.