Calculated dimension on two fields

[bharathkamath28]

Hi All/@sunny_talwar 

I am not able to achieve this scenario.

I have a bar chart.

My calculated condition is 

=if( count(distinct Month)>2, Month, Year)

tried with aggr() function

= if ( aggr (count(distinct Month)>2 , ID), Month, Year)

Still not working for me.

Please any one help me on this.

Thanks,

[Surya]

Hello ,

I'm Not getting you exact one But simply do

if(not wildmatch(month,1,2),month,year)

[tresesco]

May be this?

= aggr (If(count(distinct Month)>2 , ID), Year,ID)

[bharathkamath28]

No, its not working for me.

I have to calculate the (distinct month) first.

Based on this (distinct month) value, i have to pass either Month or Year in the dimension for Bar Chart

[tresesco]

Could you explain your expected output with a sample data set?

[bharathkamath28]

I have attached the sample data.

Suppose if i select ID=2, then bar chart dimension should be Year. 

if i select ID=3 and ID=1 then bar chart dimension should be Month.

I have to include count(distinct Month) in my calculation --> this is the key.

[bharathkamath28]

Please check this sample data

[tresesco · Accepted solution]

Try this:

=if ( $(=count(distinct Month)>2) , [Month], [Year])

[bharathkamath28]

Thanks!!.. This is working fine.

I got the other way for this scenario 

By creating variable vCount=if(count(distinct Month)>12,1,0)

dimension= pick(match($(vCount),1,0),Year,Month)

[bharathkamath28]

Hi @tresesco 

With the below expression i see the formula in the selection bar.

=if ( $(=count(distinct DateA)>12) , Year(DateA), date(DateA,'DD:MMM:YYYY'))

How to resolve these kind of issues.

Thanks,