Best Of
Re: Formatting Summary Number For A Calculation
You need to move your closed span tag to be after your numbers. Should look like this:
CONCAT('<span style="color: ##004387; font-size: 32px; font-weight: bold;">$', ROUND(SUM(Cost) / SUM(Leads), 0), '</span>')
Re: Switch Dataset Dynamically
You could append two datasets together and switch back and forth with a filter or a variable - but I agree with @MichelleH, more information is needed.
Re: Bryan Van Kampen Joins the Ranks as the Community's Newest Coach!
Congrats!!! A well deserved title and glad to see more coaches as the community grows 🤩
Re: Bryan Van Kampen Joins the Ranks as the Community's Newest Coach!
Conrgats @trafalger! Welcome to the club 😎
Ashleigh
Re: Datediff per month
Hey @user046467,
I would use something like:
period_diff(date_format(`date_stage_changed`, '%Y%m'),date_format(`date_created`, '%Y%m'))
This will get the number of months between two dates without having to make sure they are in the correct format to begin with.
Best,
Nick

