Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to keep Month,Day& week in same chart with if condition.
Inline script:
Load * Inline
[
Charts
Day
Week
Month
];
Dimension:
If(wildmatch(Charts,'Month'),Month(dt),if(Wildmatch(Charts,'Week'),Weekday(dt),day(dt)))
Given Charts as filter, based on selection of filter dimension will work,
Issue is when selecting week is not showing weekday properly, its showing like jun,sun,mon(refer below image).
As per my requirement alternate dimension will not work properly. help me to resolve this weekday.
How to resolve.
You need to wrap your dimension in an aggregate:
=aggr(
If(wildmatch(Charts,'Month'),
Month(dt),
if(Wildmatch(Charts,'Week'),
Weekday(dt),
Day(dt)
)
),
dt
)
You need to wrap your dimension in an aggregate:
=aggr(
If(wildmatch(Charts,'Month'),
Month(dt),
if(Wildmatch(Charts,'Week'),
Weekday(dt),
Day(dt)
)
),
dt
)