importing just one item from exist table

[nazaninslp]

Dears

I have one chart that shows all of my offers and the usage and count of qualified subscribers that is connected to one table,

now I want just show one of them(from connected table) in other chart separately, would you please help me how can I seperate it in one chart that show just one item that I want.

for exampale:

I have below table

I want to import just first item in my dashboard not whole of them.

Thank you

[felipedl]

Hi Nazanin,

you can use set analysis for it, like so:

let's say you want average daily data usage

avg({<[CAMPAIGN_NAME]={"1 GB Churn Same day"}>}Data)

Bolded part is the set analysis, which lets you filter on a graph a specific dimension value.

Felipe.

[nazaninslp]

Hi Felip

it is not matter AVG,SUM or ..., I just want to show and inport just one campaign name and its value like a piture that I have shared before.

but when i want import the campaign name , all of campaigns name imported in table, I just want to one of them not whole.

would you please help.

[felipedl]

When loading your campaign table, use the [CAMPAIGN_NAME] as a where clause

Campaign:

Load

    *

From [Whatever]

Where [CAMPAIGN_NAME]="1 GB Churn Same day"

That will only load one campaign.

[nazaninslp]

Dear Felip

in other sheet I need my all campiagns list and their usage, so if i limited the campiagn_name just for mentioned item, the others will not load.

is there any way to do it in expression part.

Thank you for your big cooperation.

[felipedl · Accepted solution]

It's exactly what I pointed out before, use set analysis in expression, like:

avg({<[CAMPAIGN_NAME]={"1 GB Churn Same day"}>}Data)

Or whatever other campaign name you want.

This will only get one campaign in the expression, even though you loaded all of them.