How do I present a particular field data with distinct count?

Question & Answer
, , ,
1

Hi team,
I need you help, In the attached picture I want all the table data separately on the basics of job status by using Distinct Count of job name so any idea how can I do this?
Distinct Count On the Basics of Field Data

2

Hi @Biswajit_1993 , can you elaborate your request? Do you want distinct count of job name for each job status? Seems the screenshot has already provided what you need?

3

Yes @emilyzhu like I want a separate columns for all the job_status field data by using calculated field.
e.g.- For null-85 —> Separate Null Column
For failed-5 —> Separate failed Column
For skipped-41 —> Separate skipped Column
For success-1426—> Separate success Column
For upstrem_failed-65 —> Separate upstream_failed Column

4

Hi @Biswajit_1993,
What you are trying to accomplish can be achieved using visual type pivot table. Your job_status field would need to be added as column and the job_name (Count distinct) as value.

If you don’t want the metric’s name (job_name) to be displayed in each column, you can hide it using the Hide single metric option in the Pivot options in the Format visual menu (clicking the pen icon on the visual).