topic How to split up a row into multiple rows? in Dashboards & Visualizations

topic How to split up a row into multiple rows? in Dashboards & Visualizations https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616952#M50667 <P>Hi all,<BR /><BR />I have a table with these fields -</P><P> </P><TABLE border="1" width="88.81589638700962%"><TBODY><TR><TD width="10%" height="25px"><STRONG>Time/Date</STRONG></TD><TD width="29.005328596802844%" height="25px"><STRONG>Key</STRONG></TD><TD width="1.7761989342806392%" height="25px"><STRONG>Robot</STRONG></TD><TD width="5%" height="25px"><STRONG>Process</STRONG></TD><TD width="10%" height="25px"><STRONG>Host</STRONG></TD><TD width="10%" height="25px"><STRONG>Status</STRONG></TD><TD width="10%" height="25px"><STRONG>Environment</STRONG></TD><TD width="10%" height="25px"><STRONG>Type</STRONG></TD></TR><TR><TD width="10%" height="47px">01.01.2022<BR />12:30:00</TD><TD width="29.005328596802844%" height="47px"><P>Key 1<BR /><BR />Key 2</P><P>Key 3</P></TD><TD width="1.7761989342806392%" height="47px"><P>Robot 1</P><P>Robot 2</P><P>Robot 3</P></TD><TD width="5%" height="47px"><P>Process Claim</P><P>Process Claim</P><P>Process Claim</P></TD><TD width="10%" height="47px"><P>Host W</P><P>Host X</P><P>Host Y</P></TD><TD width="10%" height="47px"><P>Success</P><P>Success</P><P>Success</P></TD><TD width="10%" height="47px"><P>Production</P><P>Production</P><P>Production</P></TD><TD width="10%" height="47px"><P>Critical</P><P>Critical</P><P>Critical</P></TD></TR><TR><TD>01.01.2022<BR />12:30:00</TD><TD><P>Key 4</P></TD><TD><P>Robot 4 </P></TD><TD><P>Process Refund</P></TD><TD><P>Host Z</P></TD><TD><P>Success</P></TD><TD><P>Production</P></TD><TD><P>Critical</P></TD></TR><TR><TD width="10%" height="52px">02.02.2022<BR />11:30:00</TD><TD width="29.005328596802844%" height="52px">Key 5</TD><TD width="1.7761989342806392%" height="52px">Robot 5</TD><TD width="5%" height="52px">Process Tax</TD><TD width="10%" height="52px">Host V</TD><TD width="10%" height="52px">Failed</TD><TD width="10%" height="52px">Non-Production</TD><TD width="10%" height="52px">Minor</TD></TR></TBODY></TABLE><P> </P><P>I want to split up the first row into three rows to show the data. Is there a way I can split these based on the Time/Date and the Process? </P><P>Ideally, I want to generate a new table like this -</P><TABLE border="1" width="669px"><TBODY><TR><TD width="94.0139px" height="25px"><STRONG>Time/Date</STRONG></TD><TD width="148.986px" height="25px"><STRONG>Key</STRONG></TD><TD width="56.7778px" height="25px"><STRONG>Robot</STRONG></TD><TD width="71.2083px" height="25px"><STRONG>Process</STRONG></TD><TD width="56.7083px" height="25px"><STRONG>Host</STRONG></TD><TD width="71.5833px" height="25px"><STRONG>Status</STRONG></TD><TD width="105.722px" height="25px"><STRONG>Environment</STRONG></TD><TD width="63px" height="25px"><STRONG>Type</STRONG></TD></TR><TR><TD width="94.0139px" height="173px">01.01.2022<BR />12:30:00</TD><TD width="148.986px" height="173px"><P><BR />Key 1<BR /><BR /><BR /></P><P> </P></TD><TD width="56.7778px" height="173px"><P> </P><P>Robot 1</P><P> </P><P> </P></TD><TD width="71.2083px" height="173px"><P>Process Claim</P><P> </P></TD><TD width="56.7083px" height="173px"><P>Host W</P><P> </P></TD><TD width="71.5833px" height="173px"><P>Success</P><P> </P></TD><TD width="105.722px" height="173px"><P>Production</P><P> </P></TD><TD width="63px" height="173px"><P>Critical</P><P> </P></TD></TR><TR><TD width="94.0139px" height="62px">01.01.2022<BR />12:30:00</TD><TD width="148.986px" height="62px"><P>Key 2</P></TD><TD width="56.7778px" height="62px"><P>Robot 2</P></TD><TD width="71.2083px" height="62px"><P>Process Claim</P></TD><TD width="56.7083px" height="62px"><P>Host X</P></TD><TD width="71.5833px" height="62px"><P>Success</P></TD><TD width="105.722px" height="62px"><P>Production</P></TD><TD width="63px" height="62px"><P>Critical</P></TD></TR><TR><TD width="94.0139px" height="62px">01.01.2022<BR />12:30:00</TD><TD width="148.986px" height="62px"><P>Key 3</P></TD><TD width="56.7778px" height="62px"><P>Robot 3</P></TD><TD width="71.2083px" height="62px"><P>Process Claim</P></TD><TD width="56.7083px" height="62px"><P>Host Y</P></TD><TD width="71.5833px" height="62px"><P>Success</P></TD><TD width="105.722px" height="62px"><P>Production</P></TD><TD width="63px" height="62px"><P>Critical</P></TD></TR><TR><TD width="94.0139px">01.01.2022<BR />12:30:00</TD><TD width="148.986px"><P>Key 4</P></TD><TD width="56.7778px"><P>Robot 4 </P></TD><TD width="71.2083px"><P>Process Refund</P></TD><TD width="56.7083px"><P>Host Z</P></TD><TD width="71.5833px"><P>Success</P></TD><TD width="105.722px"><P>Production</P></TD><TD width="63px"><P>Critical</P></TD></TR><TR><TD width="94.0139px" height="52px">02.02.2022<BR />11:30:00</TD><TD width="148.986px" height="52px">Key 5</TD><TD width="56.7778px" height="52px">Robot 5</TD><TD width="71.2083px" height="52px">Process Tax</TD><TD width="56.7083px" height="52px">Host V</TD><TD width="71.5833px" height="52px">Failed</TD><TD width="105.722px" height="52px">Non-Production</TD><TD width="63px" height="52px">Minor</TD></TR></TBODY></TABLE><P> </P><P> </P> Thu, 13 Oct 2022 09:32:14 GMT cris887 2022-10-13T09:32:14Z How to split up a row into multiple rows? https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616952#M50667 <P>Hi all,<BR /><BR />I have a table with these fields -</P><P> </P><TABLE border="1" width="88.81589638700962%"><TBODY><TR><TD width="10%" height="25px"><STRONG>Time/Date</STRONG></TD><TD width="29.005328596802844%" height="25px"><STRONG>Key</STRONG></TD><TD width="1.7761989342806392%" height="25px"><STRONG>Robot</STRONG></TD><TD width="5%" height="25px"><STRONG>Process</STRONG></TD><TD width="10%" height="25px"><STRONG>Host</STRONG></TD><TD width="10%" height="25px"><STRONG>Status</STRONG></TD><TD width="10%" height="25px"><STRONG>Environment</STRONG></TD><TD width="10%" height="25px"><STRONG>Type</STRONG></TD></TR><TR><TD width="10%" height="47px">01.01.2022<BR />12:30:00</TD><TD width="29.005328596802844%" height="47px"><P>Key 1<BR /><BR />Key 2</P><P>Key 3</P></TD><TD width="1.7761989342806392%" height="47px"><P>Robot 1</P><P>Robot 2</P><P>Robot 3</P></TD><TD width="5%" height="47px"><P>Process Claim</P><P>Process Claim</P><P>Process Claim</P></TD><TD width="10%" height="47px"><P>Host W</P><P>Host X</P><P>Host Y</P></TD><TD width="10%" height="47px"><P>Success</P><P>Success</P><P>Success</P></TD><TD width="10%" height="47px"><P>Production</P><P>Production</P><P>Production</P></TD><TD width="10%" height="47px"><P>Critical</P><P>Critical</P><P>Critical</P></TD></TR><TR><TD>01.01.2022<BR />12:30:00</TD><TD><P>Key 4</P></TD><TD><P>Robot 4 </P></TD><TD><P>Process Refund</P></TD><TD><P>Host Z</P></TD><TD><P>Success</P></TD><TD><P>Production</P></TD><TD><P>Critical</P></TD></TR><TR><TD width="10%" height="52px">02.02.2022<BR />11:30:00</TD><TD width="29.005328596802844%" height="52px">Key 5</TD><TD width="1.7761989342806392%" height="52px">Robot 5</TD><TD width="5%" height="52px">Process Tax</TD><TD width="10%" height="52px">Host V</TD><TD width="10%" height="52px">Failed</TD><TD width="10%" height="52px">Non-Production</TD><TD width="10%" height="52px">Minor</TD></TR></TBODY></TABLE><P> </P><P>I want to split up the first row into three rows to show the data. Is there a way I can split these based on the Time/Date and the Process? </P><P>Ideally, I want to generate a new table like this -</P><TABLE border="1" width="669px"><TBODY><TR><TD width="94.0139px" height="25px"><STRONG>Time/Date</STRONG></TD><TD width="148.986px" height="25px"><STRONG>Key</STRONG></TD><TD width="56.7778px" height="25px"><STRONG>Robot</STRONG></TD><TD width="71.2083px" height="25px"><STRONG>Process</STRONG></TD><TD width="56.7083px" height="25px"><STRONG>Host</STRONG></TD><TD width="71.5833px" height="25px"><STRONG>Status</STRONG></TD><TD width="105.722px" height="25px"><STRONG>Environment</STRONG></TD><TD width="63px" height="25px"><STRONG>Type</STRONG></TD></TR><TR><TD width="94.0139px" height="173px">01.01.2022<BR />12:30:00</TD><TD width="148.986px" height="173px"><P><BR />Key 1<BR /><BR /><BR /></P><P> </P></TD><TD width="56.7778px" height="173px"><P> </P><P>Robot 1</P><P> </P><P> </P></TD><TD width="71.2083px" height="173px"><P>Process Claim</P><P> </P></TD><TD width="56.7083px" height="173px"><P>Host W</P><P> </P></TD><TD width="71.5833px" height="173px"><P>Success</P><P> </P></TD><TD width="105.722px" height="173px"><P>Production</P><P> </P></TD><TD width="63px" height="173px"><P>Critical</P><P> </P></TD></TR><TR><TD width="94.0139px" height="62px">01.01.2022<BR />12:30:00</TD><TD width="148.986px" height="62px"><P>Key 2</P></TD><TD width="56.7778px" height="62px"><P>Robot 2</P></TD><TD width="71.2083px" height="62px"><P>Process Claim</P></TD><TD width="56.7083px" height="62px"><P>Host X</P></TD><TD width="71.5833px" height="62px"><P>Success</P></TD><TD width="105.722px" height="62px"><P>Production</P></TD><TD width="63px" height="62px"><P>Critical</P></TD></TR><TR><TD width="94.0139px" height="62px">01.01.2022<BR />12:30:00</TD><TD width="148.986px" height="62px"><P>Key 3</P></TD><TD width="56.7778px" height="62px"><P>Robot 3</P></TD><TD width="71.2083px" height="62px"><P>Process Claim</P></TD><TD width="56.7083px" height="62px"><P>Host Y</P></TD><TD width="71.5833px" height="62px"><P>Success</P></TD><TD width="105.722px" height="62px"><P>Production</P></TD><TD width="63px" height="62px"><P>Critical</P></TD></TR><TR><TD width="94.0139px">01.01.2022<BR />12:30:00</TD><TD width="148.986px"><P>Key 4</P></TD><TD width="56.7778px"><P>Robot 4 </P></TD><TD width="71.2083px"><P>Process Refund</P></TD><TD width="56.7083px"><P>Host Z</P></TD><TD width="71.5833px"><P>Success</P></TD><TD width="105.722px"><P>Production</P></TD><TD width="63px"><P>Critical</P></TD></TR><TR><TD width="94.0139px" height="52px">02.02.2022<BR />11:30:00</TD><TD width="148.986px" height="52px">Key 5</TD><TD width="56.7778px" height="52px">Robot 5</TD><TD width="71.2083px" height="52px">Process Tax</TD><TD width="56.7083px" height="52px">Host V</TD><TD width="71.5833px" height="52px">Failed</TD><TD width="105.722px" height="52px">Non-Production</TD><TD width="63px" height="52px">Minor</TD></TR></TBODY></TABLE><P> </P><P> </P> Thu, 13 Oct 2022 09:32:14 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616952#M50667 cris887 2022-10-13T09:32:14Z Re: How to split up a row into multiple rows? https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616955#M50669 <P>Hi <a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/250299">@cris887</a>,</P><P>only one information: does the above table arrive from a search or or does it come as I can see?</P><P>if from a search, you have to modify your search to have the result you want, if it is as I see, you have to define some rule for the splitting.</P><P>Ciao.</P><P>Giuseppe</P> Thu, 13 Oct 2022 09:29:54 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616955#M50669 gcusello 2022-10-13T09:29:54Z Re: How to split up a row into multiple rows? https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616956#M50670 <P>Hi <a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>,</P><P> </P><P>I have modified my original post to make it clearer. I get these results from a search.</P> Thu, 13 Oct 2022 09:32:47 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616956#M50670 cris887 2022-10-13T09:32:47Z Re: How to split up a row into multiple rows? https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616963#M50674 <P>Hi <a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/250299">@cris887</a>,</P><P>if you could share your search, maybe I can modify it to split the values.</P><P>Ciao.</P><P>Giuseppe</P> Thu, 13 Oct 2022 09:58:10 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616963#M50674 gcusello 2022-10-13T09:58:10Z Re: How to split up a row into multiple rows? https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616972#M50677 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a> </P><P>index=insurance source=* sourcetype=_json</P><P>| fields Time/Date, Key, Robot, Process, Host, Status, Environment, Type</P><P> </P><P> </P> Thu, 13 Oct 2022 11:27:00 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-split-up-a-row-into-multiple-rows/m-p/616972#M50677 cris887 2022-10-13T11:27:00Z