3 Replies Latest reply on Jan 19, 2015 8:02 AM by William Peterson

# Square pie charts/waffle charts II

I realize there is a thread on this already, but since I am not getting a response on a question I posted there, I thought I ll try and post it in a separate thread.

Example of what I mean by a square pie chart:

Firstly, please see the data file I am attaching here. The first tab has the sample data, and the 2nd tab shows the calculation I wish to report.

I wish to create similar waffle charts except that i wish to chart the % out of total for A, B, and C. A,B,C belong to one dimension (Media).

I would also want to add the market filter, so that the charts change dynamically based on the market chosen.

Regards,

Shalin.

• ###### 1. Re: Square pie charts/waffle charts II

This is definitely going to be a table calculation situation... a while back I made a square type of chart with some similarities, but I had a natural block unit dimension (one part) , while you don't. So I created one ... a new sheet in your table called 'index' with two columns, j: 1,2,3 ... ,100 and join: 1,1,1,....,1 and a new column to your existing data; join 1,1,1,....,1

Then I joined the existing table to the new table on the join column.

now you can drop j in your Detail to be your block unit, and use mod: ([Last]-1) %10 and i: Round((([Last] -1) / 10.0)+0.5,0)

Shape is driven by a calc: IF ([Spend Increment]*[Last] <= [Spend by Pane] ) THEN 'filled' ELSE 'empty' END

Spend increment is the amount of money in one box, or WINDOW_SUM(SUM([Spends]))/100

Spend by pane is simply WINDOW_SUM(SUM([Spends]))

Color is driven by Media.  Market filter just works.

Since there are 100 boxes, the number of filled boxes naturally coincides with the % of total.