I Have the following Display
Domain Application ReportingMonth Price
ADD Dotnet 1/1/2016 $1000
DotNet
DotNet
Java
Java
ABV Javac 2/1/2016 $10000
DotNet
DotNet
Java
Java
ABB DotNet 3/1/2016 $1200
DotNet
Java
Java
I want the above to be displayed in this format
1-2016 2-2016 3-2016 Domain ApplicationGroup
$1000 $10000 $1200 Java ABB
$1000 $10000 $1200 Dotnet XYZ
$1000 $10000 $1200 sap abv
how can I do it? i have already user xyseries and mvindex and split command. but the results aren't coming
Try this
base search resulting in the view described in your question | mvexpand Application | eval Domain=Domain."#".ApplicationGroup | chart values(Price) as Price over Domain by ReportingMonth | rex field=Domain "(?<Domain>[^#]+)#(?<ApplicationGroup>.*)" | table Domain ApplicationGroup *