SQL Query

SQL Query

by Mehmet Sancak Sahin -
Number of replies: 1

Hi everyone,

I started to use SQL queries to build a report for my needs. I used the Ad-Hoc dokument as a guide. The query below is copied from Ad-Hoc

Here is my Query, sorry for the german language btw... This query did work and i continued as Ad-Hoc guide tells...

Here is my Query, Sorry for the German Language btw...

This is the screenshot of choosung a Calculation model. I should choose the Sum and than take the"hits" for the column. The problem starts here, i dont know why but i can not see the Column as a Choice in drop-down-Menu. The Drop down Menu is actualy empty. There is noting in it.Drop down Menu for Columns

I continued and tried to choose a Value and a Name for my Plot. But the same here, there are no choices in both Drop down menüs. Menüs are empty.Plot ddmenüs

Does anyone have an idea, how can i fix this??


Thx

Average of ratings: -
In reply to Mehmet Sancak Sahin

Re: SQL Query

by Shirley Gregorczyk -
Picture of Particularly helpful Moodlers
Those tabs are when you use the Import report from repository feature.
When you add a report, you can use this feature....and then the tabs will be active and populated.
When you use SQL code, no tabs.


Average of ratings: -