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

sho
sho Member
編集済： May 2023 で 仲間に相談

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

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

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

コメント

  • ST_Superman
    ST_Superman Domo Employee

    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.

    Snag_fd9e49e.png

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

    Snag_fdc4e0c.png 
    Average: %_VALUE
Count: %_TOOLTIP1

    This will give you something like this for you labels:

    Snag_fdcfa88.png

    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.

カテゴリ