I am trying to achieve a bar chart with 2 dimensions however I am have only one field comuln with rather "dirty" information.
What I am trying to achieve is a date column however, I have expressions in the form of 2015 P01, F1, 2015 Q1... etc and the list goes on. The F1 named data points are erroneous and can be negated.
Eventually I would like to end up with 2015 P01 to 2015 P12 for my dates for the first dimension, and the Sum of 2015 as the second dimension. What is the method that you guys propose I use?