Combination chart with data from dataset (e.g. average) and record data so that one record can be benchmarked to the whole dataset.

[Johan]

Hi there,

I am trying to make a benchmark chart where the current record within a dataset is compared to the dataset average. 

THere is no problem getting the current datarecord fields, however, they cannot be included in the chart:  the chart functionality does not allow to select current record data, only average, sum, min, max, etc.

Anyone done this before ?

Thanks

 

[Barbie]

Hello @Johan, may I know how are you getting the current data record fields? If this can be done using formula inside table, I suggest creating a formula field in the table and call this formula field inside your Chart instead. 

Hope this helps.

 

[Barbie]

Here's additional information for reference:

https://howto.caspio.com/datapages/charts/

https://howto.caspio.com/tables-and-views/data-types/formula-fields