Hello Everyone: Today, we will see how we can create a bar graph like structure with straight table using images instead of conventional bars.
Let's take an example (Filmography)
Below are the three parts of the script:
im loading it with an inserted field: Path of my image as F2 as highlighted below.
In count table I aggregate the count(Film) to languages.
In max table I pick the max(NoFilms) and assign its value to vmax variable. In out example max number of films in a particular language is 134.
I do the same to get the min number of films in a language which happens to be 8.
I create a table named Number with one field number.
The value of the number needs to hold the x axis values.
for i=1 to 9
i*vscale as number
This for loop will load multiples of vscale(16) till 9th multiple (144)
Designing the chart
|number filed will have the above values.|
create a pivot table with following dimension and measure
This will fill the image in the field only if the count(Film) for a language is greater than number in the dimension. Which means the image will be filled till it's value in the scale.
=if(Count(Film)>number,F2) in case we need out image to be shown instead of the inbuilt image.
Change the representation to image and formatting to keep aspect as below.
Change the cell border properties as below
We get a graph like below.