Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Let me start use an example to better explain myself.
I have the following table:
Object Id: O23
Student Name | Attendance |
---|---|
Tom | Y |
Steve | blank |
Jackie | Y |
Steph | Y |
I need to have a separate Text Object that Counts the amount of Attendance's specific to this table. Please let me know what the best expression would to solve this.
Many Thanks!
You can't reference the output of a chart (expression column) from another chart.
But you can create a virtual table with your expression using advanced aggregation and count the 'Y', something like
=Sum( Aggr( If( YourObjectExpresssion = 'Y',1,0), [Student Name])
Replace the italic part with the expression that returns 'Y' or blank for each student.
Is you are expecting output as Three?