Comments
-
@Hulachic5 I am glad that it worked!
-
What about adding a step before to make the pivoting more stable? You can use the formula tile to build a CASE statement that renames each observation, for example: CASE WHEN 'PAGES_QUESTION_HEADING' LIKE '%What is your last name?%' THEN 'PFC Last Name' WHEN 'PAGES_QUESTION_HEADING' LIKE '%Hours did you...%' THEN 'Hours…
-
Sorry, but I am not sure if you can just add a grand total within the ETL, probably that would be the best to do in a card? However, since you mentioned window functions you can do the same with the Rank and Window tile: Set the function as a Sum, select the column which contains your values and set it to unbounded to 0…
-
So what are you saying is that you just need a grand total? Maybe you can share an example of what you are trying to achieve
-
Test reply lol
-
Hello both, thanks for your answers. Yes, that works perfectly fine, the issue was deeper since I had a beast mode with a window function plus another column with the values. Anyhow, I had to do some ETLing to overcome this otherwise, it would have been extremely difficult to get what I wanted the way the data was…
