taek_onvi
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Week to date as JAQL query
Hi Angelina, Thanks! The result gives me these values: "values": [ [ "2022-08-18T00:00:00" ], [ "2022-08-25T00:00:00" ] ] But these are Thursdays? I'm a little confused. I would have expected 15th and 22nd Aug 2022 as these are the Mondays of these weeks.3KViews0likes0CommentsWeek to date as JAQL query
Hi, I am trying to create a jaql query that replicates what I can filter on the dashboard using the UI - filtering a date range to 'This week and last week'. But in the jaql editor, it looks like 'weeks' are not accepted as a date level, so I was wondering the best way to do this. I have currently tried: { "datasource": "reporting_data", "metadata": [ { "dim": "[dim_calendar.date]", "datatype": "datetime", "level": "weeks", "filter": { "last": { "count": 2, "offset": 0 } } } ] }3.1KViews0likes3CommentsLines on scatter chart
This seems like a very trivial question, but I couldn't seem to find an answer. If I have a scatter chart, I would also like to show the calculated average of the x- and y-axis spanning across the chart. For example if the average of the points on the x-axis is 10, then there would be a dotted line that goes from bottom of the chart to the top of the chart at x=10 and this value would be dynamic based on the points on the chart. Thanks in advance.Solved5.3KViews0likes6Comments