23 Replies Latest reply: Sep 7, 2016 3:00 PM by Cliff Clayman

# Creating a Pie Chart from Straight Table

I would like to create a Pie Chart from some data I prepared in a Straight Table.  However, I would only like to chart a portion of the data.

I only want to chart the ratio between the values on the PO row.  How can I limit the data in this straight table and turn it into a Pie Chart?  I had to create a calculated Dimension for the Po vs No PO field.

=If(Len([PO]) = 0,'No PO','PO')

• ###### Re: Creating a Pie Chart from Straight Table

What exactly is your expression that you are trying to plot here? What is PO vs No PO field here? Is this a calculated dimension as well?

• ###### Re: Creating a Pie Chart from Straight Table

I am trying to plot the data in the PO row.  The number of Invoices in comparison to the number of POs.  Yes, the PO vs No PO field is a calculated dimension.

• ###### Re: Creating a Pie Chart from Straight Table

I guess what is the issue you are running into here? You are using a single expression or multiple expressions? Would you be able to provide a sample

• ###### Re: Creating a Pie Chart from Straight Table

I only want to be able to plot one set of the data.  How do I limit the data to just plot the PO data in the Pie Chart?

• ###### Re: Creating a Pie Chart from Straight Table

You can use set analysis for that, but if PO vs No PO is not a field, what is the field that can be used to determine if the row is PO data or not? Assuming PO vs No PO was a field, you could have done this...

{<[PO vs No PO] = {'PO'}>}

• ###### Re: Creating a Pie Chart from Straight Table

No, it is not a field, it is a calculated dimension.

• ###### Re: Creating a Pie Chart from Straight Table

Can you share how your raw data looks like?

• ###### Re: Creating a Pie Chart from Straight Table

It looks just like what I posted.  FY is a field.  I do a Count DISTINCT on POs and a SUM for Invoices.  PO vs No PO is a calculated dimension that I posted earlier.

Sometimes we have an Invoice without a PO and I am trying to show the ratio of the occurrences when we do have a PO with an Invoice.

• ###### Re: Creating a Pie Chart from Straight Table

But you have been telling me that PO vs No PO is a calculated dimension, right? How do you create it? I just don't know how you differentiate between PO and No PO

• ###### Re: Creating a Pie Chart from Straight Table

=If(Len([PO]) = 0,'No PO','PO')

That is how.  If the PO field is blank or essentially = 0, then there is No PO.

• ###### Re: Creating a Pie Chart from Straight Table

May be a set analysis like this:

{<[PO] = {"=Len(Trim(PO)) > 0"}>}

• ###### Re: Creating a Pie Chart from Straight Table

Where do I put this?

• ###### Re: Creating a Pie Chart from Straight Table

In your expression so that you only get the PO line.

• ###### Re: Creating a Pie Chart from Straight Table

Something is wrong with the syntax...Garbage after expression: '='

• ###### Re: Creating a Pie Chart from Straight Table

I just used the Set Analysis you provided.  Is it to be added to an existing expression?  Here is my expression for PO:

=Count(DISTINCT [PO])

• ###### Re: Creating a Pie Chart from Straight Table

Might be sunny suggestion is this?

Count( {<[PO] = {"=Len(Trim(PO)) > 0"}>} <Target-Value>)Re: Creating a Pie Chart from Straight Table

• ###### Re: Creating a Pie Chart from Straight Table

Anil -

This -> =Count(DISTINCT {<[PO] = {"=Len(Trim(PO)) > 0"}>} [PO])

• ###### Re: Creating a Pie Chart from Straight Table

That makes all my PO counts 0

• ###### Re: Creating a Pie Chart from Straight Table

Cliff -

Would you be able to provide a sample? I think I don't have good understanding of what is needed. Would you be able to provide a sample in the Excel file?

• ###### Re: Creating a Pie Chart from Straight Table

It's really difficult to provide an example.  Couldn't I somehow use the Conditional property and limit the results that way?

• ###### Re: Creating a Pie Chart from Straight Table

Can you share sample application as Talwar asked

• ###### Re: Creating a Pie Chart from Straight Table

This is what I ended up doing for my two expressions:

=Count(DISTINCT If(FY=vFY_Current and Len([PO]) <> 0, [PO]))

=Sum(If(FY=vFY_Current and Len([PO]) <> 0, [Invoice]))

Would set analysis work better here?