Hi @ilze.leite,
Can I remove the below highlighted in the attached file.
Regards,
Maheshwar Reddy Maccha
Hi @ilze.leite,
Can I remove the below highlighted in the attached file.
Regards,
Maheshwar Reddy Maccha
HI,
You may open the calculation formula of measure “Project overview - formatted” used in this demo report and remove the code defining the line “see more details in community post” (last lines after the final END):
The demo report formula without this line would look:
-- this measure creates a string value as a Markdown and works with Markdown formatter
CASE WHEN [Measures].[Story Points due] > 0
THEN
-- overall info about planned points, H1 style is used:
"# Points to go : " || Cast([Measures].[Story Points due] as string)
|| chr(10) || '### ' ||
-- check planned points in active sprint compared to velocity red arrow down for less
CASE When
-- if there are story point planned in acitve sprints, let''s check the differene with velocity
([Measures].[Story Points created],
[Sprint].[Active Sprints]) > 0
THEN
-- new line
"Points in active sprint: " ||
CASE WHEN
[Measures].[Story Points Velocity 5 Sprints] >
([Measures].[Story Points created],
[Sprint].[Active Sprints])
THEN
Cast (
-- points in active sprint
([Measures].[Story Points created],
[Sprint].[Active Sprints]) as String
)
-- show status for less
|| "<i class='far fa-arrow-down' style='color:red'></i>"
ELSE
Cast (
-- points in active sprint
([Measures].[Story Points created],
[Sprint].[Active Sprints]) as String
)
-- show status for more
|| "<i class='far fa-arrow-up' style='color:green'></i>"
END
END
-- new line
|| '<br>' ||
-- case for date if date is overdue display it red, if there is no date display red warning
CASE
WHEN IsEmpty([Measures].[Active Sprint end date])
THEN
"<span style='color:red'>No active sprints</span>"
WHEN DateCompare(
"Today",
[Measures].[Active Sprint end date]
) > 0
THEN
"Active sprint end date is overdue: <span style='color:red'>" || Format([Measures].[Active Sprint end date], 'Medium Date') || "</span>"
ELSE
"Active sprint end date: " || Format([Measures].[Active Sprint end date], 'Medium Date')
END
END
Best,
Ilze, support@eazybi.com