Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoI know that this is easy on a regular Summary report. I will have to now test if it's possible on a chart!
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- RubyKapil26 years agoQrew CaptainThanks Mark. The image we are using is company's icon that is a Pie with different colored pieces. Each piece represents a different part of the project process. I was able to break up the pie into the different wedges. I was trying to figure out how to override the 3 to a row, and rows grid for placement of buttons on a dashboard. I appreciate the help.
------------------------------
Ruby Kapil
rubykapil@wi-finity.com
Wi-Finity, Inc
------------------------------- RubyKapil26 years agoQrew CaptainAnd to add, even if I had solved the how to break free of the grid layout on dashboards, I still have no idea how to use the wedges as buttons. Thanks.
------------------------------
Ruby Kapil
rubykapil@wi-finity.com
Wi-Finity, Inc
------------------------------ - MarkShnier__You6 years ago
Qrew Legend
Can you post an image of what you mean in your post above.
But regardless, my suggestion would be to use a Summary report but for the Group By Rows and the columns if you are using Column Grouping, to use a Formula Rich Text Hyperlink field with an Image as the thing to click on as opposed to words. Post back if you need help with the syntax for that hyperlink.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- MarkShnier__You6 years ago
Qrew Legend
Here is a screen shot of a summary report with an icon that is drillable into any target URL, such as a dashboard. So not a piechart but a graphical looking summary report.
Here is he formula
var text WordsOne = "<img src=https://images.quickbase.com/si/48/002-music.png>";
var text WordsTwo = "<img src=https://images.quickbase.com/si/48/054-winlogo.png>";
var text Words = If(Rem([Record ID#],2)=0, $WordsOne, $WordsTwo);
var text URL = "http://www.google.com";
"<a target=_blank href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------