dbt-labs / dbt-labs/semantic-layer-tableau-connector

Dates / Time Dimensions / Metric Time Not pulling in - Saved Queries

Open
#6 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
No language data
Stars
3
Forks
2
PR merge metrics
No merged PRs in 30d

Description

We have created a saved query but when pulling it into tableau neither the TimeDimension does not pull through.

`version: 1

saved_queries:
- name: sq_tc_metrics
label: TC Metrics
description: Trade Credit exposure metrics with daily granularity and key dimensions
query_params:
metrics:
- tc_current_exposure_zar
group_by:
- "TimeDimension('metric_time','day')"
'

`version: 2

saved_queries:
- name: sq_tc_metrics
label: TC Metrics
description: Trade Credit exposure metrics with daily granularity and key dimensions
query_params:
metrics:
- tc_current_exposure_zar
group_by:
- "TimeDimension('exposure_current_snapshot_credit__metric_time','day')"
'

version: 3

saved_queries:
- name: sq_tc_metrics
label: TC Metrics
description: Trade Credit exposure metrics with daily granularity and key dimensions
query_params:
metrics:
- tc_current_exposure_zar
group_by:
- "TimeDimension('exposure_current_snapshot_credit__snapshot_date','day')"

Version 3 gets me to the closest option although the date field doesnt show in Tableau - Please help

Image

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.