Forum Discussion

SabineOussi's avatar
SabineOussi
Icon for Skilled Sharer rankSkilled Sharer
10 years ago
Solved

Dynamic Text

Hello,   Is there a way that I can create a dynamic text within the text box?   In other words, let's say I want to display the following: There are @numberoftickers submitted by @numberofusers ...
Need Help
Tips and Tricks
  • SqlJason's avatar
    SqlJason
    10 years ago

    What you can do is to create a measure like 

    TextMeasure = "There are " +  [numberoftickers] + " submitted by " + [numberofusers] + " and managed by " + [numberofadmins]

     

    Now you can place this measure in a text box and that should show the desired result. Using text based measures is a handy technique in scenarios like this. 

MrDataGeek's avatar
MrDataGeek
New Member
10 years ago

SqlJason how do you set a textbox to the value of a measure? I was able to create a measure that returns a dynamic title using your method but I don't know how to set a textbox a measure. I was able to do so using the "card" visualization but I don't want to use that visualization because it uses the name of the measure as a default title. 

SabineOussi's avatar
SabineOussi
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

MrDataGeek it is a card visualization and not a textbox. You can turn off the category label, turn on the title and put the title text you want.

  • MrDataGeek's avatar
    MrDataGeek
    New Member
    10 years ago

    Thanks SabineOussi! I figured that out last night and I was about to update my question before I saw your response. I did not initially think to turn off the "category label". I appreciate your help!