Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have one chart with one dimension in that all data is showing perfectly but my requirement in below chart I want to display Q3 bar after it completed means after 31-Dec-15 .
I don't want to display bar for Q3.
PFA..
Thanks
There could be many solutions. One is using calculated dimension like:
Aggr(If(Count(Distinct Date)=3,QuarterYear),QuarterYear)
PFA
Not very clear!
Could you post a sample screenshot how the output should look like?
Hi Tresesco,
I don't want bar for Q3 for time being because Q3 is not completed yet. It should display but after 31th December month sales happens.
So I want completed Quarter ...
Q4 Should display on 1st April 2016
PFA I don't want highlighted bar
you can try something like
1. Create a master calendar
2. add a quarter_end_flag in the master calendar, with the help of it do a resident load of qurater that have a quarter_end_flag
3. use this field in as chart dimension.
-Sundar
Hi PFA,
Try to use a flag to control the display of your dimension and expression. Please see attached the flag that I have added to your graph properties tabs:
Kind Regards,
Arohan
There could be many solutions. One is using calculated dimension like:
Aggr(If(Count(Distinct Date)=3,QuarterYear),QuarterYear)
PFA
Put below calculated dimension & check Suppress when value is null
=aggr(if( monthname(max(Date))=monthname(QuarterEnd(max(Date))),QuarterYear),QuarterYear)
Hi All,
Can anyone tell me same for Months I want bar for completed months.
Dim: MonthYear
PFA I don't want highlighted bar
I'd use this as a formula for the dimension and expression
if(MonthEnd<Today(),MonthYear)
try this
=aggr(if( monthname(max(Date))=monthname(MonthEnd(max(Date))),MonthYear),MonthYear)