Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count uniqe values existing in two variable tables

Hi, I have two connected tables.   The first one (Table1) cointains sales data with unique client ID and date among other things. The second one (Table2) is a simple table with dates. I'm trying a...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Try this

    Countrows(union(table1,table2))

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try this

Countrows(union(table1,table2))

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a lot!

     

    I don't know if you meant Countrows(union(table1,table2)) or Countrows(union(currMonthColumn, lastMonthColumn))

    But the second one worked as expected 😁

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I have given generalized answer so have to replace it by using existing table or virtual tables which you stored in visual.

       

      You replaced it correctly.

       

      Thanks & regards,
      Pravin Wattamwar
      www.linkedin.com/in/pravin-p-wattamwar

      If I resolve your problem Mark it as a solution and give kudos.