How can I have the data (text type) distinct counted in Analyzer?
I want distinct count for Y axis rather than count, How can I do it ?
Thanks in advance.
Best Answers
-
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:
If I solved your problem, please select "yes" above
1 -
Okay for your summary number use this:
AVG(COUNT(DISTINCT 所在库位) FIXED (BYDate
))That will give you the average unique count over the entire time period by date for the group total.
If I solved your problem, please select "yes" above
1
Answers
-
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:
If I solved your problem, please select "yes" above
1 -
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.
0 -
For that you can use a nested beastmode:
Create a new beastmode that references your count distinct.AVG(その他の計算フィールド)
Then select this new field as your summary number.
If I solved your problem, please select "yes" above
0 -
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?
0 -
Okay for your summary number use this:
AVG(COUNT(DISTINCT 所在库位) FIXED (BYDate
))That will give you the average unique count over the entire time period by date for the group total.
If I solved your problem, please select "yes" above
1 -
It really works, thank you!!
0 -
@ColemenWilson Hello coach, can you help me on below? thank you in advance.
I made a little change on the design because I want the distinct count for 所在库位(the Chinese means each storage location's name) to be shown as pallet quantity.
there are 3 types of 所在库位,large size, middle size and small size.
for large size, 1 storage location is equal to 1 pallet
for middle size, 1 storage location is equal to 0.25 pallet
for small size, 1 storage location is equal to 0.067 pallet
I need all the number shown on DOMO card is pallet quantity rather than storage location quantity.
there are one month's data which shows on each day of the month on each storage location what kind of products are stored. Same day, same storage location may have several rows of data.
previous design in beast mode: storage location quantity=count( distinct ’库位名称‘)
current design in beast mode: storage pallet quantity= sum( distinct ’ 托盘库位数折算‘) fixed( by ’库位名称‘)
托盘库位数折算 the Chinese means the ratio to convert storage location to pallet, that is, 1, or 0.25, or 0.067
I select storage pallet quantity to Y axis. the DOMO card shows exactly what i want. the figure is totally right.
BUT the problem is at the Summary Number again.
previous design in summary number: AVG( 'storage location quantity') fixed (by 'Date'). it works and figure is right.
current design in summary number: AVG( 'storage pallet quantity') fixed (by 'Date'). this time it doesn't work.
I can't figure out why and failed to get it fixed. so I come to you. do you know where the problem is and how to fix it?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive