Forum Discussion

abgnfirdaus's avatar
abgnfirdaus
Helper I
4 years ago
Solved

count test frequency

Hello there. I need help for my problem here. Let say the table is below: Date tested Equipment no. Red cable  Yellow cable Blue cable 24/2/2019 TRU1 0.1 0.1 0.1 25/2/2019 TRU2 0....
Need Help
Show and Tell
Tutorial Requests
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    HI abgnfirdaus ,

     

    Create a column with below code just in case if any of the column is blank 

    Column = COALESCE('Table'[Red cable ],'Table'[Yellow cable],'Table'[Blue cable])

    then use this new column as count on your visual

    output:-

     

    Thanks,

    Samarth

     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

HI abgnfirdaus ,

 

Create a column with below code just in case if any of the column is blank 

Column = COALESCE('Table'[Red cable ],'Table'[Yellow cable],'Table'[Blue cable])

then use this new column as count on your visual

output:-

 

Thanks,

Samarth

 

abgnfirdaus's avatar
abgnfirdaus
Helper I
4 years ago

How to create a custom column to count how frequent the equipment have been tested.

Table 1:

Date TestedEquipmentRed cableYellow cableBlue cable
1/2/2018TRU 10.10.120.1
2/2/2018TRU 20.120.140.12
2/2/2018TRU 30.120.110.1
3/4/2020TRU 20.20.240.21
5/4/2020TRU30.210.220.21
4/6/2021TRU30.310.360.31


I want to create new column that will count the frequency of equipment have been tested. The table should show like this:

EquipmentCount of test
TRU 11
TRU 22
TRU 33


Hope you guys can help me. thank you in adavance.