Forum Discussion
lachlanP
Helper II
Helper IIHow to return a string instead of (Blank)
I have a tooltip page which displays the time of an event when it is hovered over on a line chart - this works well. The field being used in the card on the tooltip is a Time Only type and has a summ...
Perhaps try one of these:
event1Time tooltip = var result = MIN(event1table[eventTime]) & "" return if( result = BLANK(), "Not Detected", result ) event1Time tooltip = var result = MIN(event1table[eventTime]) & "" return if( result = "#,0.00", "Not Detected", result )
Greg_Deckler
Community Champion
Community ChampionPerhaps try one of these:
event1Time tooltip =
var result = MIN(event1table[eventTime]) & ""
return
if(
result = BLANK(),
"Not Detected",
result
)
event1Time tooltip =
var result = MIN(event1table[eventTime]) & ""
return
if(
result = "#,0.00",
"Not Detected",
result
)
lachlanPHelper II
Helper IIThanks Greg_Deckler , the first measure worked:
event1Time tooltip = var result = MIN(event1table[eventTime]) & "" return if( result = BLANK(), "Not Detected", result )
It now displays the time instead of the "#,0:00".
Could you help me understand what adding the & "" did to solve this? Does this force it to format result as a string?
Thanks!
- Greg_Deckler
lachlanP Bingo, forces it to a string.