Post reply

RADAR CHARTS

  • November 11, 2017 at 4:36 am

    #402664

    So at work I need to create a Radar chart that utilises information from another dataset in my project.

    I can't seem to use LOOKUPS in the expressions.

    Example.

    Create dataset RadarTemp.
    select 1 as RadType,'Apples' as RadItem,20 as RadAmount union all
    select 2 as RadType,'Apples' as RadItem,20 as RadAmount union all
    select 3 as RadType,'Apples' as RadItem,20 as RadAmount union all

    So I assign the value as RadAmount etc and thats all fine,however i can't use the VARIABLE in this dataset as the info I want is calculated by a lookup. So I want to do something like this in the Values box like you can on bar charts,pie,etc.
    =Lookup(Fields!RadType.Value,Fields!RadType.Value,Fields!RadAmount.Value,"GetRadAmt)

    That way I can retrieve the correct values as I would have done on my other dataset?

    What am i doing wrong pleae? Can this be done in a Radar Chart in Report Builder 3.0

    Thanks

  • November 12, 2017 at 5:56 pm

    #1967703

    I fixed it it was me.

    It can use lookups quite happily in the expression,but make sure the values are good ones on your test and i had a simple case problem with the lookup.Instead of "RadBlue" in my lookup it was "RadbLUE"

    This topic is now obselete and can be ignored.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply