Create visual for distinct count combined with summed data

Question

Hi all,&nbsp;I have been searching the internet for ages, but I can't find the exact solution I need. Hopefully one of you can help me out.&nbsp;I have a challenge with a dashboard I am building with different data sources.&nbsp;One source gives me data per record per date with unique ID'sOne source gives me data per bulk per date without unique ID's&nbsp;I want to make a stacked visual where I show the summed unique ID's and the bulk together in a visual. Currently I have a visual with only the unique ID's (see below screenshot). My goal is to have a custom column as marked bold.&nbsp;&nbsp;Can anybody help?&nbsp;DateUser Unique IDCategoryBulk count dataDistinct count per dayCars and Trains1-1-2023ABCTrain&nbsp;1&nbsp;1-1-2023ABCTrain&nbsp;&nbsp;&nbsp;1-1-2023DEFTrain&nbsp;1&nbsp;1-1-2023&nbsp;Cars250&nbsp;&nbsp;1-1-2023&nbsp;Cars&nbsp;&nbsp;2501-1-2023&nbsp;Train&nbsp;&nbsp;22-1-2023ABCTrain&nbsp;1&nbsp;2-1-2023DEFTrain&nbsp;1&nbsp;2-1-2023DEFTrain&nbsp;&nbsp;&nbsp;2-1-2023&nbsp;Cars320&nbsp;&nbsp;2-1-2023&nbsp;Cars&nbsp;&nbsp;3202-1-2023&nbsp;Train&nbsp;&nbsp;2&nbsp;&nbsp;

biswajit_das · Answer

Hello kdbbi&nbsp;Can you share the demo data for better understandingThanks &amp; Regards...

Forum Discussion

Create visual for distinct count combined with summed data

1 Reply

Related content

Tables combine

Combine distinct with lookup

DISTINCT UNION & Summarized Combined.

Counting Distinct Combinations

Folder Combine Wizard creates sample file queries but does not generate final combined query

Date	User Unique ID	Category	Bulk count data	Distinct count per day	Cars and Trains
1-1-2023	ABC	Train		1
1-1-2023	ABC	Train
1-1-2023	DEF	Train		1
1-1-2023		Cars	250
1-1-2023		Cars			250
1-1-2023		Train			2
2-1-2023	ABC	Train		1
2-1-2023	DEF	Train		1
2-1-2023	DEF	Train
2-1-2023		Cars	320
2-1-2023		Cars			320
2-1-2023		Train			2