Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
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.
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.
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.