Having an issue in SQL script where I’m trying to achieve filter criteria of rolling 12 months in the day column which stored data as a text in server. Goal is to count sizes for product at retail store location over the last 12 months from the current day. Currently, in my query I’m using the criteria of year 2019
Tag: tableau-api
Tableau calculated field : i’m trying to create calculated field in tableau
i’m trying to create calculated field in tableau, my query is below: i’m getting error saying cannot mix agreegate and non agreegate comparison. Final objective is to divide with revenue column . Please help Answer It appears that your numerator is a sum (an aggregation) but your denominator is not. Try dividing by: / sum(FLOAT([Revenue]))
How do I get result from SELECT clause after CREATE and INSERT clause?
I have a query that I intend to put into a stored procedure for ultimate use in Tableau. I am getting affected row(s) instead of the grid result. The query is as follows: IF EXISTS #A DUMP #A CREATE …