8 Replies Latest reply: Feb 2, 2010 11:13 AM by Tiziana Caem

Set Analisys question

Hi all,

I'm having some problems with a set analisys expression, someone can help me solve it? The expression is this one:

count

(distinct {\$<Anno_iscrizione = {\$(#=Only(FatAnno)-1)}, Mese_iscrizione= {\$(#=Only(FatMese))}>} CLIENTE)

I don't know if its possible to use Count disctinct in set analisys and if my synthass is correct

I would really appreciate some clarifications or indications..

thanks

Tiziana

• Set Analisys question

Hello Tiziana,

Everything seems to be allright, except for

`Count({set} DISTINCT CLIENTE)`
using DISTINCT keyword after the set. Hope this helps.

• Set Analisys question

Actually in this way works, but only if i delete the secon condition (the one of mounth)

some other idea?

• Set Analisys question

How do you store FatMese field (which format) in your data source? If you try for example to get with set analysis those who

`{< FatMese = {3} >}`
does the chart work?

• Set Analisys question

FatMese is like gen, feb, mar etc. if i use 3 is doesn't work, instead it work correct if i use mar.

• Set Analisys question

if i want to show the percentuage of single month respect the full year, is correct (but i think no as it doesn't work) this syntax:

sum

( {\$<FatAnno = {\$(#=Only(FatAnno)-1)}>} System_Net_Amount)/sum( {1<FatAnno = {\$(#=Only(FatAnno)-1)}>} total System_Net_Amount )

• Set Analisys question

Depending on how are your dimensions built (I'd recommend to add "Month" as dimension, actually), something like the following should work to get month results of total year results

`sum({\$< FatAnno = {\$(#=Only(FatAnno)-1)} >} System_Net_Amount) / sum({1< FatAnno = {\$(#=Only(FatAnno)-1)} >} System_Net_Amount)`

Hope this helps

• Set Analisys question

Bad news.. in this way the result is 100% in every row, rather than the percentage for the year that i'm considering..

For the current year (Max (TOTAL Year) ) i usually use

Sum (System_Net_Amount)/Sum (Total System_Net_Amount)

but i'm not able to translate this condition with setAnalisys for (Max (TOTAL Year) )-1

The month is already a dimension.

i don't know what to do.. any other ideas??

Thank you very much

• Set Analisys question

thank you for your help.. i find the solution writing total before the SysteNetAmount..

now is working correctly!!!