I am trying to do a single value with a sparkline that shows the total count for the months events and the spark line showing the month events without the total bump at the end. I am using | timechart count|addcoltotals for the total monthly count which shows the correct number but the sparkline is wrong. If I take off addcoltotals the sparkline is correct.
Is there any way to do this?
... View more
I got it to work but it uses input time. The time will always be -1mon and -2mon. How can I hide that so its not seen?
test
strftime(relative_time(time(), "-1mon"), "%B %Y")
strftime(relative_time(time(), "-2mon"), "%B %Y")
<panel>
<html> <p><center> <b><font size="5">$last_month$ Count</font></b></center></p></html>
</panel>
<panel>
<html> <p><center> <b><font size="5">$twoMonths$ Count</font></b></center></p> </html>
</panel>
... View more
I am on Enterprise 6.4. I have tried a different code also and have combined both in the following example. The example I found with the giraffe works but I cant get it to generate previous month.
TimeTestTakeThree
<input type="text" token="newname">
<label>labelrino</label>
<default>giraffe</default>
<change>
<eval token="Ucase">upper('value')</eval>
<eval token="leno">len('value')</eval>
</change>
<html>
<p>Raw Entry: <b>$newname$</b></p>
<p>Upper(raw):<b>$Ucase$</b></p>
<p>Length(raw): <b>$leno$</b></p>
</html>
<eval token="last_month">strftime(relative_time(time(), "-1mon"), "%b")</eval>
<panel>
<title>$last_month$</title>
</panel>
... View more
I have tried to pass a token into a panel title from a search that creates month names for last month and the month before that. I have tried using CDATA and just $xxxx$ in the title. Hellllp!
... View more