1 2 Previous Next 18 Replies Latest reply on Jul 28, 2017 5:59 AM by dantrue

    Dynamic Charting Labels not working


      Pretty new to Filemaker, but I am working on a line chart with predefined data series to show change in value of several cell markers over time. There are too many to display all of them, so I used this tutorial to create a chart in which the user can select which data points to display in the chart. Since the series labels are fixed, I created a text Field, CDNames, that concatenates the labels from different fields in the same record with a semicolon and carriage return between each one and is has the data auto-entered. I also created a calculated field CDPercentageList which is almost the same, but with the data points concatenated by calculation.


      It should look like this:

      For Record 1, CDNames = "CD45+; ¶ CD19+;......CD56+;"

      and CDPercentageList = CD45 & ";¶" & CD19 & ";¶"..... & CD56


      The checkboxes are in a checkbox set with Values from CDNames


      The chart data is selected with DataTable::WeeksPostTransfer.

      The first series name is selected with GetValue (DataTable::CDNames; 1)

      And in each subsequent series the number is replaced with the index matching the data pont.

      The first series data is selected with

      Let ([nRow = 1;

      $item = GetValue (DataTable::CDNames; nRow )];


      If ( not IsEmpty ($item);

      GetValue ( DataTable::CDPercentageList; nRow)




      The data points display fine, but the first series shown uses the data points from Series 1 with the labels from all of them, and it cannot be unselected. The other data series can be shown/hidden with the checkboxes, but the first checkbox hides the data from the data Series 2.

      I attached a picture of what it looks like now.

      I know it is complicated so let me know what I can clarify.

        1 2 Previous Next