Help Request for Chart

[msawyercke]

Hi,

I'm building various tables with  various store location attributes.  I'm now wanting to create a table that shows our unique store identifier ('PS #'), but ONLY for those stores that are scheduled for remodel.

So, in the Data Load editor, I created the following Flag:

IF ("Required?"='YES', 1, 0) as Remodel_Flag

The data loads fine, and I see the new 'Remodel_Flag' variable in my list of options, but where do I use this flag in the table so that just those PS#'s ('Remodel_Flag = 1') appear in the table?

Thanks for your help!

[sunny_talwar]

1May be use it in your expressions if you wish to restrict your table to view only those rows where Remodel_Flag = 1

{<Remodel_Flag = {1}>}

[msawyercke]

HI Sunny, Hope you are having a good day.

This expression has an error:

[PS #]{<Remodel_Flag = {1}>}

[sunny_talwar]

May be try this:

Only({<Remodel_Flag = {1}>} [PS #])

[msawyercke]

Sunny, I get an 'invalid dimension' message:

[sunny_talwar]

I thought you were using it as an expression, try this:

If(Remodel_Flag = 1, [#PS])

[msawyercke]

It is suppressing the PS # field for records where Remodel_Flag = 0, but all the records are showing in the chart (whether Remodel_Flag = 0 or 1).

Thank You, Sunny...

[sunny_talwar · Accepted solution]

Make sure this is unchecked -> Show Null Values

[msawyercke]

Thanks, Sunny - I can't even begin to tell you how much I've appreciated all your help...

Have a great day...

[sunny_talwar]

No problem Mike

I am glad I have been able to help you out with most of your queries.

Best,

Sunny