Put this in your page CSS > Inline section, static CSS file, etc.
/* BEGIN comments/chat region styles */
.t-Chat .t-Chat--own .t-Comments-icon {
margin-right: 0;
margin-left: 12px;
}
.t-Chat .t-Chat--own {
flex-direction: row-reverse;
}
.t-Chat .t-Chat--own .t-Comments-body {
align-items: flex-end;
}
.t-Chat .t-Chat--own .t-Comments-comment:after {
border-left-color: rgba(130, 130, 130, 0.3);
border-right-color: rgba(0,0,0,0);
right: none;
left: 100%;
}
/* END comments/chat region styles */
Create a Classic Report with a query like the one below. Pay attention to the comment_modifiers column. It should have the t-Chat--own class in case it's own message. This will be used to position the messages on the right.
select user_name,
comment_text,
comment_date,
apex_string.get_initials(user_name) user_icon,
null as actions,
null as attribute_1,
null as attribute_2,
null as attribute_3,
null as attribute_4,
case is_own
when 'Yes' then 't-Chat--own'
else null
end comment_modifiers
from dummy_data
order by comment_date asc
Add the t-Chat class to your Classic Report Appearance > CSS Classes field