Producing a count for number of rows on page

Viewing 1 replies (of 1 total)

  • Hi,

    Probably a little late, this worked for me:

    I’ve added stats on a table, you can see it in action here

    The shortcodes are shown below, I’ve removed my name and replaced with <table-name> but the fields are the same:

    [abase sql=”SELECT Type AS ‘Source Table’,COUNT(*) as ‘Number of Records’,COUNT(DISTINCT(Surname)) AS ‘Unique Surnames’ FROM <table-name> GROUP BY Type ORDER BY Type ASC”]

    Total number of records = [abase sql=”SELECT Count(Surname) FROM <table-name> “]

    Unique Surnames across all records = [abase sql=”SELECT COUNT(DISTINCT(Surname)) FROM <table-name> “]

    Hope this helps.

Viewing 1 replies (of 1 total)
  • The topic ‘Producing a count for number of rows on page’ is closed to new replies.