Okay finally, Mission accomplished! Thank you Jerry, for helping me go through this. Otherwise I would have undoubtably given up!

Wait, found the answer online. I've had to put "Aggregation Rule" to None... Hmmm now start over and just add month...

Okay, Filtering helped in trying to create a pivotTable. I was able to get the following result: With following SQL query: SELECT saw_0, saw_1, saw_2, saw_3, saw_4, COUNT(DISTINCT saw_2 by saw_0, saw_1, saw_4) saw_5 FROM ( (SELECT "General - (Project)"."Project Object Id" saw_0, "General - (Project)"."Project Name" saw_1,…

Okay, I think I'm in an older version as my layout is slightly different. However if I add a Pivot Table it gives me the same error as before And the problem is: once you have an error you can't change the visual or anything. So I'm wondering if this is a Catch-22 situation, or in which order I should execute it to get the…

Hmmm okay, adding a by statement solves that error. I now have something: But this give me way too many lines to add in a graph of any sort. If I try to start creating a line chart for instance it gives me this error. So obviously I should remove one column from the table (Activity ID). However if I remove it in the table…

OK, ok thanks so much, quite clear and you've helped me a lot in understanding. I'm nearly there, I guess. I've had another error on the way: => Set operation failed due to incompatible sort order. But this has been resolved by using a 'Union All' instead of a normal Union. But now I've got this one after adding a Count…

Yes, You're right! Can it also be a case of having the correct permissions (if so I just have to file a service request). Otherwise I'll try to see if I can recreate the SQL Myself. Will it impose the same restrictions as the visual way I tried before? As in: is it ever possible to do a COUNT DISTINCT before the union? If…

Hey Jerry I tried your approach, as it was the most visual. This was a promising course, put some hours into it (which is why it took >1 day to reply), however I couldn't get it to work. First time I tried it I got the error: "The data view layout builder was unable to create the proper grid view layout. The logical column…

Is this always possible? If I go to New-> Analysis I only have the availability to select from existing Models. If I go to New-> Dataset I do have the option to create a new SQL Query. but this one I can only access in reports, not in analyses, right?

Okay, Thank you very much! I'm a bit unsure whos answer I should mark as "the correct one" because now I have two viable ways of making it work! I was able to do edit my previous filter this way. When in SQL edit mode, I saw that the apostrophes were not in the formula where I placed them in the calculated column. So I…

I checked now to the advance tap to check what SQL is being generated. there it says: WHERE (("General - (Activity)"."Activity Status" IN ('In Progress', 'Not Started')) AND ("General - (Project)"."Project Object Id" IN ( SELECT saw_1 FROM (SELECT "General - (Project)"."Project Name" saw_0, "General - (Project)"."Project…

Thanks for this! It really did what I needed. at first I didn't realise I had to use an external filter to filter this visual, but once I did that it went smoothly! So solution = - Prompt that asks for Project_Name and stores it in a variable : varProject - Analysis1 that has two fields: Project_Name and ProjectID, filter…

Hi Jerry, That looks like what I wanted to do. However, where can I define that Filter? I tried doing it in the filter of the analysis or in a separate filter, but neither have the proper effect. Or at least I wasn't able to manage.

Okay, that was already really helpfull. I've created a column prompt instead of a variable prompt and used the Method you said to create a combined field. CONCAT(CONCAT(TRIM(BOTH FROM CAST("General - (Project)"."Project Object Id" AS CHAR(10))), '|'), "General - (Project)"."Project Name") However If I now create the same…