Thursday, December 10, 2015

Multi-Value Performance Tile

This post is a bit of a diversion from my working with Maps since it revolves around a requirement I had with a client.

We have all seen the Performance Tile.  It provides a quick instant view of key metrics.

 
 


We can use conditional formatting to indicate a change from target or values within a threshold.  The one limitation of a Performance Tile is that it holds 1 and only 1 value.

What if you wanted to show a tile with Current Value as well as Month Ago Value and Year Ago Value so that you could quick see how you are performing in context of time?

 
 
I had such a request from a client. And after some playing around I figured why try to do this with a Pivot or other visualization.  Why not use a couple of tiles in the compound view and when put on the Dashboard the tile looks whole and tells a better story than a single value.
 
 First I looked at the original Tile to get an idea about the size.
 
 
Then I adjust the size so that it is about 2/3 the original height
 
 


Next I modify my Analysis to bring in the other 2 values.
 

Then create 2 new tiles with the height 1/3 the original height.  The key to this working is also adjusting the font sizes and checking the option Do Not Autofit.

 
Finally I put it all together in my compound layout.


 

 Then on the Dashboard next to the original tile.

 
 
All it takes now is a bit of fine tuning.
 
Well that was fun, until next time.
 


25 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. What an awesome and very nice post. I just stumbled upon your weblog and wanted to say that I’ve really enjoyed browsing your blog posts.

    In any case I will be subscribing to your rss feed and I hope you write again very soon!


    pave tile - website

    ReplyDelete
  3. Organic products are becoming more popular all the time, but many people still argue about whether or not they are really better than other foods. This article takes a closer look at the issue by discussing the differences between organic and regular foods, as well as the implications for your health. Buy Lumion 9.5

    ReplyDelete
  4. Cash is the lifeblood of a business. No business owner wants to see their business struggling because of lack of funds or in debt due to mismanaged finances. What they want to see is a regular flow of profit but this is easier said than done. https://cad.cheapsoftwaredownload.net/

    ReplyDelete
  5. One of the most commonly asked questions regarding search engine optimization is: "What is the best way to learn SEO"? The answer I always give to this question is simple yet complex. My answer to this question is always: "It Depends". white hat link building

    ReplyDelete
  6. One of the most commonly asked questions regarding search engine optimization is: "What is the best way to learn SEO"? The answer I always give to this question is simple yet complex. My answer to this question is always: "It Depends". seo marketing

    ReplyDelete
  7. One of the most commonly asked questions regarding search engine optimization is: "What is the best way to learn SEO"? The answer I always give to this question is simple yet complex. My answer to this question is always: "It Depends". blog commenting for backlinks

    ReplyDelete
  8. I don’t usually comment but I gotta state thanks for the post on this great one : D. 먹튀

    ReplyDelete
  9. i think that RSS FEEDS should also be included on the list of the best inventions because it makes life easier for bloggers like us,. 먹튀검증

    ReplyDelete
  10. Hey there! Nice stuff, please keep us posted when you post again something like that! 안전놀이터

    ReplyDelete
  11. I like what you guys are up also. Such clever work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my website rentacar kosovo 카지노

    ReplyDelete
  12. Hi, I just found your weblog via google. Your viewpoint is truly pertinent to my life at this moment, and I’m really happy I found your website. 먹튀검증

    ReplyDelete
  13. Hi, I just found your weblog via google. Your viewpoint is truly pertinent to my life at this moment, and I’m really happy I found your website. Mega888 game client download

    ReplyDelete
  14. We harmonise together with your results and then leave desperately seem modern for your returning revisions. 먹튀검증

    ReplyDelete
  15. I’ve writers block that comes and goes and I need to find a way to get rid of my writers block. It can occasionally be so bad I can barley make sentences. Any tips?
    918kiss xe88 apk download

    ReplyDelete
  16. Vos traité : bon plusieurs sûrs thèmes de conflit pourtant je discute de la véracité de la plupart des arguments affichés ci dessus dans cet ultime étude; 918kiss kiss918 apk download

    ReplyDelete
  17. oh i just hate the fat pads that i got, my fat pad is just genetics so i can’t do anything about it** 토토사이트

    ReplyDelete
  18. I would like to express my respect for your generosity giving support to folks who have the need for help with this theme. Your special commitment to getting the solution across was extraordinarily informative and has all the time helped some individuals much like me to realize their ambitions. The warm and friendly useful information denotes a lot to me and a whole lot more to my office workers. Best wishes; from everyone of us. 파워볼사이트

    ReplyDelete
  19. 이 얼마나 멋진 게시물이었습니다. 이런 종류의 유용한 게시물을 본 적이 없습니다. 나는 당신에게 감사하고 이와 같은 더 많은 게시물을 기대합니다. 감사합니다 먹튀검증

    ReplyDelete
  20. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more. 토토검증

    ReplyDelete
  21. Thanks a lot for sharing us about this update. Hope you will not get tired on making posts as informative as this. 스포츠토토

    ReplyDelete
  22. Thanks for picking out the time to discuss this, I feel great about it and love studying more on this topic. It is extremely helpful for me. Thanks for such a valuable help again. 안전놀이터

    ReplyDelete
  23. I’m still learning from you, while I’m improving myself. I certainly enjoy reading everything that is written on your website.Keep the posts coming. I loved it! 먹튀검증

    ReplyDelete
  24. Hello, i think that i saw you visited my site so i came to “return the favor”.I am attempting to find things to enhance my site!I suppose its ok to use a few of your ideas!! f95zone games

    ReplyDelete
  25. Many people click pictures every day but, few of them know that how these different photography types have been inspiring photographers? When we get to know the different photography types, we gain the knowledge of different genre which may fit to our photography habits. newborn photography Props

    ReplyDelete