Hi @niketnilay
bellow is my xml so bottom i am using 5 table instead of 5 i want to use only one table can you plz elaborate your answer.
<panel>
<title>New CRs</title>
<html class="html">
<div class="help-tip">
<p>This view provides the New CRs in the last 48 hrs and Drilldown table with information of the CRs.</p>
</div>
</html>
<single>
<search>
<query>|`macro_ChangeRequest_JIRA`|search "CR State"="*"|table _time "Request item" "CR State" Created|eval _time=coalesce(strptime('Created',"%Y-%m-%d"),strptime('Created', "%d-%b-%y")) |timechart span=1w count|streamstats sum(count) as "count"</query>
<earliest>-48h</earliest>
<latest>now</latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">none</option>
<option name="drilldown">all</option>
<option name="height">80</option>
<option name="linkView">search</option>
<option name="numberPrecision">0</option>
<option name="rangeColors">["0x65a637","0x6db7c6"]</option>
<option name="rangeValues">[0]</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">New CRs</option>
<option name="unitPosition">before</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="link.visible">0</option>
<drilldown target="_self">
<set token="NewCR_tok">$click.value$</set>
<unset token="Opencr_tok"></unset>
<unset token="OpenCR_tok"></unset>
<unset token="OnHoldCR_tok"></unset>
</drilldown>
</single>
</panel>
<panel>
<title>Open CRs</title>
<html class="html">
<div class="help-tip">
<p>This view provides the number of Open CRs and Drilldown table with information of the CRs.</p>
</div>
</html>
<single>
<search>
<query>|`macro_ChangeRequest_JIRA`|search "CR State"!="Closed Incomplete (Cancelled)" "CR State"!="Closed Skipped (Rejected)" "CR State"!="Closed Complete" "CR State"!="On Hold"|table _time "Request item" "CR State" "JIRA #" Created|eval _time=coalesce(strptime('Created',"%Y-%m-%d"),strptime('Created', "%d-%b-%y")) |timechart span=1w count|streamstats sum(count) as "count"</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">none</option>
<option name="drilldown">all</option>
<option name="height">80</option>
<option name="linkView">search</option>
<option name="numberPrecision">0</option>
<option name="rangeColors">["0x65a637","0x6db7c6"]</option>
<option name="rangeValues">[0]</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">Open CRs</option>
<option name="unitPosition">before</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="link.visible">0</option>
<drilldown target="_self">
<set token="OpenCR_tok">$click.value$</set>
<unset token="Opencr_tok"></unset>
<unset token="NewCR_tok"></unset>
<unset token="OnHoldCR_tok"></unset>
</drilldown>
</single>
</panel>
<panel>
<title>Open Unassigned CRs</title>
<html class="html">
<div class="help-tip">
<p>This view provides the New CRs in the last 48 hrs and Drilldown table with information of the CRs.</p>
</div>
</html>
<single>
<search>
<query>|`macro_ChangeRequest_JIRA`|search "CR State"!="Closed Skipped (Rejected)" "CR State"!="Closed Incomplete (Cancelled)" "CR State"!="Closed Complete"|eval _time=coalesce(strptime('Created',"%Y-%m-%d"),strptime('Created', "%d-%b-%y")) |timechart span=1w count|streamstats sum(count) as "count"</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">none</option>
<option name="drilldown">all</option>
<option name="height">80</option>
<option name="linkView">search</option>
<option name="numberPrecision">0</option>
<option name="rangeColors">["0x65a637","0x6db7c6"]</option>
<option name="rangeValues">[0]</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">Open Unassigned CRs</option>
<option name="unitPosition">before</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="link.visible">0</option>
<drilldown target="_self">
<set token="Opencr_tok">$click.value$</set>
<unset token="NewCR_tok"></unset>
<unset token="OpenCR_tok"></unset>
<unset token="OnHoldCR_tok"></unset>
</drilldown>
</single>
</panel>
<panel>
<title>On Hold CRs</title>
<html class="html">
<div class="help-tip">
<p>This view provides the number of open On Hold CRs and Drilldown table with information of the CRs.</p>
</div>
</html>
<single>
<search>
<query>|`macro_ChangeRequest_JIRA`|search "CR State"="On Hold"|table _time "CR State" Created|eval _time=coalesce(strptime('Created',"%Y-%m-%d"),strptime('Created', "%d-%b-%y")) |timechart span=1w count|streamstats sum(count) as "count"</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">none</option>
<option name="drilldown">all</option>
<option name="height">80</option>
<option name="linkView">search</option>
<option name="numberPrecision">0</option>
<option name="rangeColors">["0x65a637","0x6db7c6"]</option>
<option name="rangeValues">[0]</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">On Hold CRs</option>
<option name="unitPosition">before</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="link.visible">0</option>
<drilldown target="_self">
<set token="OnHoldCR_tok">$click.value$</set>
<unset token="Opencr_tok"></unset>
<unset token="NewCR_tok"></unset>
<unset token="OpenCR_tok"></unset>
</drilldown>
</single>
</panel>
<panel>
<title>Pending for CAB Approval</title>
<html class="html">
<div class="help-tip">
<p>This view provides the CR'S which are in Pending status for CAB Approval.</p>
</div>
</html>
<single>
<search>
<query>|`macro_ChangeRequest_JIRA`|search "CR State"="Internal CAB - Estimates for Review/Approval"|table "CR State" Created|eval _time=coalesce(strptime('Created',"%Y-%m-%d"),strptime('Created', "%d-%b-%y")) |timechart span=1w count|streamstats sum(count) as "count"</query>
<earliest>0</earliest>
<latest></latest>
<refresh>48h</refresh>
<refreshType>delay</refreshType>
</search>
<option name="colorBy">value</option>
<option name="colorMode">none</option>
<option name="drilldown">all</option>
<option name="height">80</option>
<option name="linkView">search</option>
<option name="numberPrecision">0</option>
<option name="rangeColors">["0x65a637","0x6db7c6"]</option>
<option name="rangeValues">[0]</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">Pending For CAB Approval</option>
<option name="unitPosition">before</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
<option name="link.visible">0</option>
<drilldown target="_self">
<set token="CABPending_tok">$click.value$</set>
<unset token="Opencr_tok"></unset>
<unset token="OpenCR_tok"></unset>
<unset token="OnHoldCR_tok"></unset>
</drilldown>
</single>
</panel>
<panel depends="$NewCR_tok$">
<input type="checkbox" token="tokReset1" searchWhenChanged="true">
<label></label>
<change>
<unset token="NewCR_tok"></unset>
<unset token="form.tokReset1"></unset>
</change>
<choice value="hide">Hide Details</choice>
<delimiter> </delimiter>
</input>
<table>
<title>New CRs details</title>
<search>
<query>|`macro_ChangeRequest_JIRA`|fields "CR State" "PO/PM" "Request item" reated "Created By" "Requestor Country" Application "PO/PM"|rename "Requestor Country" as Region|search "CR State"="*"|rename "Request item" as RequestItem|fillnull value="Not Available"|table RequestItem "CR State" "PO/PM" Application Region</query>
<earliest>-48h</earliest>
<latest>now</latest>
</search>
<option name="drilldown">none</option>
<option name="link.visible">0</option>
</table>
</panel>
<panel depends="$OpenCR_tok$">
<input type="checkbox" token="tokReset2" searchWhenChanged="true">
<label></label>
<change>
<unset token="OpenCR_tok"></unset>
<unset token="form.tokReset2"></unset>
</change>
<choice value="hide">Hide Details</choice>
<delimiter> </delimiter>
</input>
<table>
<title>Open CRs details</title>
<search>
<query>|`macro_ChangeRequest_JIRA`|fields "CR State" "PO/PM" "Request item" Created "Created By" "Requestor Country" Application "PO/PM"|rename "Requestor Country" as Region|search "CR State"!="Closed Skipped" "CR State"!="Closed Incomplete" "CR State"!="Closed Complete" "CR State"!="On Hold" "CR State"!="Closed Incomplete (Cancelled)""CR State"!="Closed Skipped (Rejected)"|rename "Request item" as RequestItem|fillnull value="Not Available"|table RequestItem "CR State" "PO/PM" Application Region</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="drilldown">none</option>
<option name="link.visible">0</option>
</table>
</panel>
<panel depends="$Opencr_tok$">
<input type="checkbox" token="tokReset" searchWhenChanged="true">
<label></label>
<change>
<unset token="Opencr_tok"></unset>
<unset token="form.tokReset"></unset>
</change>
<choice value="hide">Hide Details</choice>
<delimiter> </delimiter>
</input>
<table>
<title>Open Unassigned CRs details</title>
<search>
<query>|`macro_ChangeRequest_JIRA`|fields "CR State" "JIRA #" "Request item" Created "Created By"|search "CR State"!="Closed Skipped" "CR State"!="Closed Incomplete" "CR State"!="Closed Complete" "CR State"!="Closed Incomplete (Cancelled)" "CR State"!="Closed Skipped (Rejected)"|rename "Request item" as RequestItem|table RequestItem "CR State" "Created By"</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="drilldown">none</option>
<option name="link.visible">0</option>
</table>
</panel>
<panel depends="$OnHoldCR_tok$">
<input type="checkbox" token="tokReset3" searchWhenChanged="true">
<label></label>
<change>
<unset token="OnHoldCR_tok"></unset>
<unset token="form.tokReset3"></unset>
</change>
<choice value="hide">Hide Details</choice>
<delimiter> </delimiter>
</input>
<table>
<title>On Hold CRs details</title>
<search>
<query>|`macro_ChangeRequest_JIRA`|fields "CR State" "PO/PM" "Request item" Created "Created By" "Requestor Country" Application "PO/PM"|rename "Requestor Country" as Region|search "CR State"="On Hold"|rename "Request item" as RequestItem|fillnull value="Not Available"|table RequestItem "CR State" "PO/PM" Application Region</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="drilldown">none</option>
<option name="link.visible">0</option>
</table>
</panel>
<panel depends="$CABPending_tok$">
<input type="checkbox" token="tokReset4" searchWhenChanged="true">
<label></label>
<change>
<unset token="CABPending_tok"></unset>
<unset token="form.tokReset4"></unset>
</change>
<choice value="hide">Hide Details</choice>
<delimiter> </delimiter>
</input>
<table>
<title>CAB Approval Pending CRs details</title>
<search>
<query>|`macro_ChangeRequest_JIRA`|fields "CR State" "PO/PM" "Request item" Created "Created By" "Requestor Country" Application "PO/PM" CAB_Approval|search CAB_Approval="Pending"|rename "Request item" as RequestItem|fillnull value="Not Available"|table RequestItem "CR State" "PO/PM" Application Region</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="drilldown">none</option>
<option name="link.visible">0</option>
</table>
</panel>
... View more