Forum Discussion

jbowler's avatar
jbowler
Regular Visitor
10 years ago
Solved

Calculated fields in text boxes

Hi Community

 

I have a column chart showing a data series, x axis time periods

 

for the last column (most recent period) I want to float the value in extra large font in the centre above the chart -

 

Is it possible to do this via a text box linked to a value in the data? Not disimilar to Excel 2013 where you can pass cell links to shapes to show certain values

 

thanks

  • Anonymous's avatar
    Anonymous
    10 years ago

    jbowler

    You can drop your "count" into a table visual, move your "column/date" field into the filter area (Visual Level Filters), select only the date you want, and change the visual to a "Card". Then you can resize that a bit, play with the background transparency and place it over the column chart. It may provide what you are looking for, but there isn't anything you would be able to place on the same surface plane as the chart. ie. you can't snap in or embed visuals to other visuals.

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Sounds like you just need a new visualization filtered for your most recent period placed above your column chart.

    • jbowler's avatar
      jbowler
      Regular Visitor

      that's it exactly.

       

      How do I do that please?

      • Anonymous's avatar
        Anonymous
        Not applicable

        jbowler

        You can drop your "count" into a table visual, move your "column/date" field into the filter area (Visual Level Filters), select only the date you want, and change the visual to a "Card". Then you can resize that a bit, play with the background transparency and place it over the column chart. It may provide what you are looking for, but there isn't anything you would be able to place on the same surface plane as the chart. ie. you can't snap in or embed visuals to other visuals.