Dear seemaadhav,
short question because I would like to understand the root of the problem more in depth. Above you have suggested two different methods for implementation. One based on timeGroupAlias and an alternative approach without it. In your last posting you have provided a reasonable explanation why the timeGroupAlias approach might not work in context of InfluxDB. However, your second suggestion does not rely on this function. Do you have any idea why this works neither?
I am just curious and want to attain a better understanding of the problem.
Thanks in advance and kind regards,
Roman.