Discussions

 View Only

Possibility to filter by "# of Records" in report.

  • 1.  Possibility to filter by "# of Records" in report.

    Posted 06-09-2021 06:54
    Hi,

    I have two related table. Table A is parent for table B. In table B I have the field "Name".

    Now I would like to show all the records in table B, where value in "Name" field is identical but related record "A" is different.

    What I did is:
    I created chart in table A with "Name" field on x axis and "# of Records" (field calculated by Quickbase, not created by me) on y axis.
    Now I can see all records with bar value higher than 1 means I have duplicated "Names" in table B.

    Is there any possibility to use "# of Record" in filters and filter out all records where # of Records < 2?​

    ------------------------------
    Piotr Kryszkiewicz
    ------------------------------