To GoodData homepage

Topics started by Vasiliy Ostrovsky

4 Topics

V
Vasiliy OstrovskyKnown Participant
asked in Metrics and MAQL

Some metrics don't work

We're having trouble with a metric that calculates the ratio of the number of candidate_id with the status "Hired" to the total number of candidate_id. We first tried to evaluate this MAQL query, but it doesn't work.SELECT(SELECT COUNT({attribute/dshb_recruiting_ratio.job_posting_candidate_id}) WHERE {label/dshb_recruiting_ratio.application_status} = "Hired")/COUNT({attribute/dshb_recruiting_ratio.job_posting_candidate_id})Then we tried to calculate two independent  metricsand then to calculate the ratioSELECT TRUNC({metric/recruiting_ratio_status_hired} / {metric/recruiting_ration_total}, 4) or SELECT TRUNC({metric/recruiting_ratio_status_hired}, 4) / TRUNC({metric/recruiting_ration_total}, 4)This didn't work either. We received an error messagejava.sql.SQLException: exception while executing query: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join. If a cartesian or inequality join is used intentionally, set the op

7
U
GoodData Employee
2 years ago
V
Vasiliy OstrovskyKnown Participant
asked in Dashboards and Reports

Export of existing workspace to an empty one

Hi! I'm trying to export an existing workspace by sending the GET request. Then I save the response as JSON file, send the PUT request to another empty workspace and get an error: Some of given referenced 'labels' entities do not exist. What should I do to import saved workspace data to another empty workspace? Labels marked in response as "not exisiting" exist in LDM as foreign keys  

1
V
2 years ago
V
Vasiliy OstrovskyKnown Participant
asked in Dashboards and Reports

Dashboard filters in GoodData CN

Hi! Could you please help me to set up dashboard filters?I have two vidgets on the dashboard, each vidget has its own dataset as datasourse ("Dshb recruiting ratio" and "Dshb open job posting"). Both datasets have the "Employer "attribute. I'm trying to place the "Employer" filter on dashboard so it'd affect both vidgets. But in current configuration it doesn't work. I have to add two different filters based on Dshb_recruiting_ratio.Employer and Dshb_open_job_posting.Employer as "OJP Employer" each of them affecting corresponding vidget. Is there any way to configure single Employer filter affecting both widgets? PS I'm using GoodData CN.  

2
J
GoodData Employee
2 years ago
V
Vasiliy OstrovskyKnown Participant
asked in Dashboards and Reports

Incorrect filtering of running sums

Hi! I’m facing following problemWhen I choose Sum in measures and set date filter to All time, I get these data When I set data filter to This year I get the same data but filtered by year 2021. And it looks right. When I choose Running sum in measures and set date filter to All time, I get running sums groupped by years. It’s still right When I try to filter running sums by This year I expect to get running sum filtererd by ths year, in this expample - 1327. But  I get the Sum (not Running sum) - 51. Is there a way to get what I expect? 

9
V
2 years ago
Welcome to the GoodData Community!Cookie settings