I need to calculate the days count based on the user query from Search. Currently I am using a calculated field as below,
days count = (dateDiff(min({Local Time At}),max({Local Time At}),“DD”)+1)
If I query days count it is giving 7 for last week and 31 for last month and so on.
But if I use it in another calculated filed , it is taking how many days the data is present for.
How to find the days count in generic level and not based on the data in Topic Search?
Hi @Max ,
This is with respect to Topic in Quicksight
I need to use the days count in one of the calculated field. How to do it based on the user query dynamically.?
eg. For last week - days count is 7
For last month - days count is 31
Consider if I need to calculate stop time , and I need days count based on user query dynamically.
stop time = (24 * days count) - trip duration
Query from user in topic : show me the stop time for last week by vehicle
it should be (24 * 7) - 60