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

     

amitchandak's avatar
amitchandak
Super User
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
      Super 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