Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My problem is this:
I need to create a table with 2 dimensions, when one of the dimensions need to be created by using "Group By" (meaning, need 2 other dimensions in itself in order to be calculated).
I thought about creating and calculating the first "grouped by" dimension by the script, and then using that field as a dimension in order to create my desired table.
I'm using the following in my script:
AppClicks:
Load
app_id_click as app_id,
text(Date(rec_date_click)) AS daily_click_date,
count( Distinct clickviewAction) as App_daily_Clicks
from D:\qv\qvd_files\Detailed\Installs_usr_action_click.qvd(qvd)
Group by (date(rec_date_click)), app_id_click;
the Script loads fine with no issues, but the results I'm getting are somehow incorrect...
Can you please:
A. Point out if you notice anything wrong with the script
B. Tell me if you know of an easier way of creating my histogram?
Thanks
Elula
I suspect your rec_date_click is Timestamp. So please use Floor function to truncate the time and like below.
In the UI design please use required data format
AppClicks:
Load
app_id_click as app_id,
Floor(rec_date_click) AS daily_click_date,
count( Distinct clickviewAction) as App_daily_Clicks
from D:\qv\qvd_files\Detailed\Installs_usr_action_click.qvd(qvd)
Group by (Floor(rec_date_click)), app_id_click;