Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I´d like to create a new dimension, where I can connect two existed dimensions (year/month) and character ", " = for example 2021, Jun.
Could I do it in calculate dimension by some formula, or should I solve it in the script?
Here I need to concatenate [MonthName] & [year].
LOAD
[year],
[month],
[date],
[currency],
Num#(impressions) as imp,
Month(Date#([month],'M')) as [MonthName]
Here [MonthName] is calculated based on this script: Month(Date#([month],'M')) as [MonthName].
The table view is just like below:-
Any help or suggestion on the script would be appreciated.
Thanks in Advance,
AK
Try this,
LOAD
[year],
[year]&','& Month(Date#([month],'M')) as MonthYear,
[month],
[date],
[currency],
Num#(impressions) as imp,
Month(Date#([month],'M')) as [MonthName]
Hi - Can I sort this filter based on the newest to the oldest timeframe?
Please help here.
You can sort by expression :
Max({1}Date)
Hi
Try like below
MakeDate(Year, Month) as MonthName
and use that in filter