Use vLookup Count field in a Chart

Forums vLooup for SharePoint Use vLookup Count field in a Chart

This topic contains 2 replies, has 2 voices, and was last updated by  Alexander Bautz 4 years, 1 month ago.

  • Author
    Posts
  • #7432

    Gerard Graham
    Participant

    Hi there

    I’ve looking to create a chart based on a count of values generated by the vLookup. As the count is done on the fly and not stored it is not possible to generate a chart. Is there a clever way of doing this?

    Thanks

    Gerry

  • #7440

    Gerard Graham
    Participant

    Hi there

    How about a static value field for a vLookup column when count/sum/average is used. Static field could be similarly named as the look up version or selected in the configuration form.

    Regards

    Gerry

  • #7447

    Alexander Bautz
    Keymaster

    Hi,
    Sorry, but vLookups does not “exist” in the parent list. The query is performed on the fly and there are no values stored.

    Your best bet is to create a chart directly targeting the child list.

    Alexander

You must be logged in to reply to this topic.