Dashboards & Visualizations

convert timeformat not responding in drilldown link search in simple xml

Explorer

convert timeformat not responding with drilldown link tag, as a result drilldown search keep on showing loading. Sample simple xml below

<row>
    <panel name="Job Statistics">
        <table>
            <title>Job Statistics</title>
            <search>
                <query>index=$index$ host=$host$ eventtype=et_job_timing | eval Time=_time | convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)| table Time, THROUGHPUT | chart values(THROUGHPUT) by Time</query>
            </search>
            <option name="drilldown">cell</option>
            <drilldown>
                <link>search?q=search index=$index$ host=$host$ eventtype=et_job_timing| eval Time=_time | convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)| table Time, THROUGHPUT | where Time = "$click.value$"</link>
            </drilldown>
        </table>
    </panel>
</row>

from above simple xml below mentioned search not responding.

search?q=search index=$index$ host=$host$ eventtype=et_job_timing| eval Time=_time | convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)| table Time, THROUGHPUT | where Time = "$click.value$"

kindly guide me on this error.

0 Karma
1 Solution

Champion

convert command It looks like no good.
Workaround:
Macro the convert.

my_macro:convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)

search?q=search index=$index$ host=$host$ eventtype=et_job_timing| eval Time=_time |‘my_macro‘| table Time, THROUGHPUT | where Time = "$click.value$"

View solution in original post

Legend

What are you trying to do? You cannot do an eval in link. Link requires a valid URL that will be launched. You can pass token values as querystring, but you will need to format them earlier. In short, what you have here will not work, but if you can explain what it is that you are trying to accomplish in your dashboard, we can help.

0 Karma

Champion

convert command It looks like no good.
Workaround:
Macro the convert.

my_macro:convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)

search?q=search index=$index$ host=$host$ eventtype=et_job_timing| eval Time=_time |‘my_macro‘| table Time, THROUGHPUT | where Time = "$click.value$"

View solution in original post

Explorer

Thanks lot. It worked perfectly.

0 Karma