Pie Chart from Three Columns

adityacc06 · 2020-08-29T20:12:35.283Z

Dear All,

I am trying to create a Pie Chart from just three Fields.

I have Database structured as shown in the following image which has three columns (1) Tower Area Construction Cost (2) Podium Construction Cost (3) Parking System Cost.
These fields are generated by the user input using multiplication formula of (Area x Rate)

PIE CHART QUERY - DATA STRUCTURE1920×986 472 KB

I have tried the following ways to create pie chart -

I have selected “do a Serch for” in my thing called “Expenses” where these columns are located. without giving any constraints

PIE CHART QUERY - 21920×989 353 KB

So Preview looks like the following image

Preview- Pie chart - no constraints798×868 96.4 KB

So it Looks like only first column value is used in Pie chart i.e Tower Construction cost.

In the second exploration, I tried giving constraints of all columns in “do a Serch for” in my thing called “Expenses” but still of no use. Image attached for reference.

PIE CHART QUERY - 31920×986 356 KB

The preview is seen below

Preview- Pie chart - With constraints803×869 98.9 KB

I just need to extract those three values from Database & Generate Pie Chart out of it.

All the values are Numeric and not the Text Field so I still don’t know how to create Tooltip & legend.

Looking urgently for some Help. !!

Thanks

alex4 · 2020-09-24T21:14:51.510Z

adityacc06:

In the second exploration, I tried giving constraints of all columns in “do a Serch for” in my thing called “Expenses” but still of no use. Image attached for reference.

Hi @adityacc06 – what Bubble element are you using for your Pie Chart in the screenshots?

Alex
TechBlocks

system · 2020-11-07T20:12:41.889Z

This topic was automatically closed after 70 days. New replies are no longer allowed.