Which view would come close to a dashboard presentation like this?

[Mahesh]

Within the limitations to existing view types (templates), I am trying to figure out how best to render a dashboard with a few key numbers presented in a dashboard like fashion.

Here’s an example I grabbed off the Net. I understand the circle would be hard to achieve. But can the layout of labels and numbers be achieved using any of the view templates?

Thanks!

I was able to get number in big font but it stayed at the top of the view, could not make it show up in center.
Likewise with the two numbers at the bottom, not sure it is possible to show them side-by-side

[Aleksi]

Your bottom row is doable if you concatenate those values together. The number 632 + average text is possible as well with the same way (with the line break). The image is the challenge because it should change depending on the average value. I’m thinking this with a Detail view.

[Mahesh]

Thanks @Aleksi. I do understand the circle is an issue. But trying to understand the other suggestions:

• If I do 632 + Average with line break and set formatting, won’t the data and label end with the same font size. Like in the example is it possible to get “632” show up much larger font than “Average”.

• How does one introduce line break in a concatenation formula? Something like “\n”

• The only way that I know to create a page like this where values are summarized from other tables is to create a dummy table and then add virtual column with formulas to bring in the summary value. For the bottom row, the virtual column would need to concatenate the summary values. Is using dummy table and virutal column the only way to achieve a dashboard view that summarizes data?

• A more basic question, how does one make data and label show up at the center of the page

[Aleksi · Accepted solution]

#1 - Yes, the font size will be identical
#2 - You can do that like…
[ColA]&CONCATENATE("
")&[ColB]
#3 - No it’s not, but it’s better way. The other way is calculating the summary in a virtual column. But then it will calclulate the same in every row which is not an effective way.
#4 - You can show data in the center with the option “Display mode” and set it as “Centered”. You can find it from the detail view’s definition.