ヒートマップでのデータラベル設定

sho
sho Member
編集済: 5月 2023 仲間に相談

ヒートマップでデータラベルを設定のVALUEを設定しています。

このVALUEは平均値を表示させるようにしています。

この平均値だけではなく、平均値を算出するのに使用しているデータ数も表示させたいのですが可能でしょうか。

コメント

  • Setting the VALUE of setting the data label in the heatmap. This VALUE is designed to display the average value.

    Is it possible to display not only this average value, but also the number of data used to calculate the average value?

    @sho - You can use the Tooltip fields to accomplish this. First you need to turn on Tooltips in the tool bar and then move a field that will calculate the "number of data" to the Tooltip Field1 section.

    Then, in the data label settings, You would type something like this

    Average: %_VALUE
    Count: %_TOOLTIP1
    

    This will give you something like this for you labels:

    Please note that the "Average: " and "Count: " labels in the data label settings are not actually calculating anything but are only used as a label. You would need to ensure that the Value was calculating the average and the tooltip was calculating the count.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman