Values getting repeated even though Group By is applied

Adhoc
#1

Hello team. I am using Helical Insight enterprise version 5.2.1. I am applying a DB function while creating the report, but it is showing repetitive values (grouping is not happening). I have already cross verified, Group By is applied. You can see in the below image multiple values of January are appearing. I have applied Monthname function
How can I fix this issue?

image

#2

Hello Yaja,

We should change the column alias after applying the DB function. Then it will work fine. In order to change the alias name, double click on travel_date, then give it an alias name. Then click on Generate report.

Thanks you,
Helical Insight Team.