Label data not display when have one param is blank

Bug reports
1

This card result can not display data label when have one param is null

But it appear again when all data label was fulfilled

I am using metabase version v0.35.3

One more question: When metabase will have option to show all data label ?

Thanks alot

2 Likes
2

Hi @vietbeo603
Without seeing the query, it's difficult to know. Can you reproduce with Sample Dataset?
Metabase already has the option to show all data labels in visualization Settings > Display > Values to show: All

image
image1920×974 102 KB

3

Not all values, I mean all data, all y axis, like you have two diferrent data line to show, you can just display once per query.

I found a way to make the label appear again by fixing the code to remove the param, I don’t know how to reproduce this case test, its seems like an accident

4

@vietbeo603 Ohh, that’s multiple series, which is currently not supported. There’s a request for that:
https://github.com/metabase/metabase/issues/11585 - upvote by clicking :+1: on the first post

5

Can you please check this query, I can not make it display label data anymore, not like last time, I just need to fill in param
https://bi.ahamove.com/question/17726?timeview=quarter&end_date=2020-03-31&city=HAN

my query is:

select date_trunc({{timeview}}, to_timestamp(first_complete_time)) as first_complete_time
        , count(distinct s.id) as total_dfd 
from supplier s 
left join custom.ops_fb f on s.id = f.id
where s.city_id in ('HAN','SGN') 
and first_complete_time between
                                case when {{timeview}} = 'week' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '1 week'))
                                     when {{timeview}} = 'day' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '1 day'))
                                     when {{timeview}} = 'month' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '1 month'))
                                     when {{timeview}} = 'quarter' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '3 month'))
                                     when {{timeview}} = 'year' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '1 year'))
                                     else extract(epoch from current_date::timestamptz) end
                                and 
                                extract(epoch from date_trunc({{timeview}}, {{end_date}}::timestamptz))
[[and city_id = {{city}}]]
and coalesce(tags::text,'') not similar to '%(GHN|PARTNER|TCH)%'
and referral_id is not null
group by 1

union all 

select date_trunc({{timeview}}, to_timestamp(first_complete_time)) as first_complete_time
        , count(distinct s.id) as total_dfd 
from supplier s 
left join custom.ops_fb f on s.id = f.id
where s.city_id in ('HAN','SGN')
and first_complete_time between
                
                case when {{timeview}} = 'week' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '10 week'))
                     when {{timeview}} = 'day' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '30 day'))
                     when {{timeview}} = 'month' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '7 month'))
                
                     else extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) - interval '15 month')) end
                and 
                case when {{timeview}} = 'week' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) + interval '1 week'))
                     when {{timeview}} = 'day' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) + interval '1 day'))
                     when {{timeview}} = 'month' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) + interval '1 month'))
                     when {{timeview}} = 'quarter' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) + interval '3 month'))
                     when {{timeview}} = 'year' then extract(epoch from (date_trunc({{timeview}}, {{end_date}}::timestamptz) + interval '1 year'))
                     else extract(epoch from current_date::timestamptz) end
[[and city_id = {{city}}]]
and coalesce(tags::text,'') not similar to '%(GHN|PARTNER|TCH)%'
and referral_id is not null

group by 1
)

select * from sample 
order by 1```
6

It will be happended when I try to put this report to a dashboard.
At first time trying, the data label still appear

7

@vietbeo603
If this is a different problem, then please open a new topic about it.
I don’t have access to your data. Can you reproduce with Sample Dataset?

8

I can not reproduce it because its seems randomly happen :expressionless:

9

@vietbeo603 Then check the browser developer console for any errors, and you can also check the Network-tab to see differences in request data (if there are any).
Otherwise a screencast video of the problem would help a lot in understanding the problem.