Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unable to replace blank values cells

Hi,   I am unable to replace the blank values with "NA". Here is the situation, there are some metric names that available in data source for the sept month but the values are empty,  and for the ...
General Comment
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a seperate table for metric_name and join back it with you table and use mertic_name from the new tbale, Then this formula should work

     

    New Table

    mertic = distinct(mertic_name )

    Also explore this option

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the reply amit.

do you know why this is not achievable in one single flat table?

 

Regards,

Dsharma

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , This what I think, You need a left join to have that. As the values are there for sep as blank you are getting that. In same table left join in not possible with a column. Once you create a new table left join is possible; and +0 or isblank can force that join in a measure