Forum Discussion

ny326n's avatar
ny326n
Frequent Visitor
8 years ago
Solved

Error in custom column in query editor

Hello everyone!   I have a table with last active dates:  User name , Last active date   What I want to do is group customers according to last active date; however, I have not found a way to do...
Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    ny326n,

     

    What about the measure option then? That can be done i guess.
    Also, you can replace errors with "No Data" as you mentioned. Go to "Transform" tab and click on "Replace Values" > "Replace Errors"



    Please read my previous reply till end.

ny326n's avatar
ny326n
Frequent Visitor
8 years ago

Thank you for you reply.

 

However, I do not want to remove the rows that contains an error, because I still like to keep the client name in the report although it does not have a date. I only want to change the error to for exampe "No date" so I don't have to see the error each time I refresh the data.

 

 

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

ny326n,

 

What about the measure option then? That can be done i guess.
Also, you can replace errors with "No Data" as you mentioned. Go to "Transform" tab and click on "Replace Values" > "Replace Errors"



Please read my previous reply till end.

  • ny326n's avatar
    ny326n
    Frequent Visitor
    8 years ago

    Thanks a lot! This works. I will also try the measure option, it might be better.

    • prateekraina's avatar
      prateekraina
      Memorable Member
      8 years ago

      Yes, do try that. It will make your report less complex and fast.

      Also, kindly give KUDOS to my answer if you think i have helped you.