Forum Discussion
Split value in column with multiple dates
Hi-
New user and of course lots of questions!
I currently have data that looks like this-
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.
Any help would be appreciated!
-C
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
Now you can delete the original column Fee.
Highlight both date colunms. On the Transform tab, click Unpivot Columns.
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
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
Now you can delete the original column Fee.
Highlight both date colunms. On the Transform tab, click Unpivot Columns.
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!
Thanks! Glad to see an active community here.
