I am relatively new to drilldowns, so this may just be a simple error in the order of my modules, but the module here isn't replacing $clicked.value$, but instead adding onto the end of the search string.
<module name="HiddenPostProcess" layoutPanel="panel_row1_col1" group="Longest Time to Level(Based on Median)" autoRun="False">
<param name="search">fields "Level Reached", "Median Time to Level"</param>
<param name="groupLabel">Longest Time to Level(Based on Median)</param>
<module name="ViewstateAdapter">
<module name="HiddenFieldPicker">
<param name="strictMode">True</param>
<module name="JobProgressIndicator">
<module name="EnablePreview">
<param name="enable">True</param>
<param name="display">False</param>
<module name="HiddenChartFormatter">
<param name="charting.secondaryAxisTitle.text">Minutes</param>
<param name="charting.chart">bar</param>
<module name="FlashChart">
<param name="width">100%</param>
<module name="HiddenSearch">
<param name="search">index=zos_gameplay event_type="level"
| transaction source_player_id maxevents=2
| stats max(played_time) as max, min(played_time) as min, min(source_player_level) as StartingLevel, max(source_player_level) AS LevelReached by source_player_id
| eval level_time=round((max - min)/60000, 2)
| where level_time>0| where LevelReached=$click.value$
| stats list(level_time) as "Time to Level" by source_player_id, source_character_name | sort +"Time to Level"</param>
<module name="ConvertToDrilldownSearch">
<module name="JobProgressIndicator"></module>
<module name="SimpleResultsHeader">
<param name="entityName">results</param>
<param name="headerFormat">Top 10 Fastest Levelers for Level $click.value$</param>
</module>
<module name="HiddenChartFormatter">
<param name="chart">bar</param>
<param name="primaryAxisTitle.text">Character Name</param>
<param name="secondaryAxisTitle.text">minutes</param>
<param name="legend.placement">none</param>
<module name="FlashChart">
<param name="width">100%</param>
<param name="height">160px</param>
</module>
</module>
</module>
</module>
</module>
</module>
</module>
</module>
</module>
</module>
</module>
The resulting search string is as follows:
search index=zos_gameplay event_type="level"
| transaction source_player_id maxevents=2
| stats max(played_time) as max, min(played_time) as min, min(source_player_level) as StartingLevel, max(source_player_level) AS LevelReached by source_player_id
| eval level_time=round((max - min)/60000, 2) | where level_time>0
| where LevelReached=$click.value$
| search "Level Reached"="9" "Median Time to Level"="66.54"
I don't want the "| search ..." to be added at the end. I just want the level value to replace $clicked.value$
Any suggestions?
... View more