topic Help Request for Chart in App Development

Help Request for Chart

msawyercke — Wed, 05 Oct 2016 18:40:27 GMT

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!

Re: Help Request for Chart

sunny_talwar — Wed, 05 Oct 2016 18:56:34 GMT

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}>}

Re: Help Request for Chart

msawyercke — Wed, 05 Oct 2016 19:03:43 GMT

HI Sunny, Hope you are having a good day.

This expression has an error:

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

Re: Help Request for Chart

sunny_talwar — Wed, 05 Oct 2016 19:06:09 GMT

May be try this:

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

Re: Help Request for Chart

msawyercke — Wed, 05 Oct 2016 19:18:32 GMT

Sunny, I get an 'invalid dimension' message:

Re: Help Request for Chart

sunny_talwar — Wed, 05 Oct 2016 19:20:19 GMT

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

If(Remodel_Flag = 1, [#PS])

Re: Help Request for Chart

msawyercke — Wed, 05 Oct 2016 19:29:53 GMT

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...

Re: Help Request for Chart

sunny_talwar — Wed, 05 Oct 2016 19:34:57 GMT

Make sure this is unchecked -> Show Null Values

Re: Help Request for Chart

msawyercke — Wed, 05 Oct 2016 19:36:46 GMT

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

Have a great day...

Re: Help Request for Chart

sunny_talwar — Wed, 05 Oct 2016 19:38:08 GMT

No problem Mike

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

Best,

Sunny