How can I have the data (text type) distinct counted in Analyzer?

Lu_zhang

I want distinct count for Y axis rather than count, How can I do it ?

Thanks in advance.

ColemenWilson

You'll need to create a beastmode:

COUNT(DISTINCT(あなたのフィールド)

Then bring this newly created beastmode (calculated field) into your card in the y-axis spot.

Here is a video on how to create beastmodes if you never have before:

https://www.youtube.com/watch?v=SpVbmZPMAsM

ColemenWilson

Okay for your summary number use this:
AVG(COUNT(DISTINCT 所在库位) FIXED (BY Date))

That will give you the average unique count over the entire time period by date for the group total.

ColemenWilson

You'll need to create a beastmode:

COUNT(DISTINCT(あなたのフィールド)

Then bring this newly created beastmode (calculated field) into your card in the y-axis spot.

Here is a video on how to create beastmodes if you never have before:

https://www.youtube.com/watch?v=SpVbmZPMAsM

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/95214#Comment_95214

It works. thank you.

On 'summary number' area, I'd like to show the average of each day's distinct count, how can I do it?

Now i can only have the distinct count of the whole month's data as below picture shown, I want the daily average of each day's distinct count.

ColemenWilson

For that you can use a nested beastmode: https://domo-support.domo.com/s/article/000005307?language=en_US Create a new beastmode that references your count distinct.

AVG(その他の計算フィールド)

Then select this new field as your summary number.

Lu_zhang

@ColemenWilson

I created the new beast mode Average storage location quantity=AVG(Storage location quantity)

the previous beast mode I've created is Storage location quantity=COUNT(DISTINCT 所在库位)

In 'Summary Number' area, when I select 'Use All Values', column 'Average storage location quantity', the result in 'Summary Number' area is wrong, do you know what the problem is？

ColemenWilson

Okay for your summary number use this:
AVG(COUNT(DISTINCT 所在库位) FIXED (BY Date))

That will give you the average unique count over the entire time period by date for the group total.

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/95357#Comment_95357

It really works, thank you!!