Create Chart with a table filtered by variable datetime

[CongPham]

Hi all,

I am a newbie and need some advices for this case.  I have a table with date columns [ALL INCIDENT], and i want to user variably date time column (from another table with out relationship) [DATE].

I could filter ALL INCIDENT with some condition,  but the database only displays true when I see database by Table type.

When I change to Chart type (like Pie chart, Stacked Bar chart), the database comes false.

Please see the screen shoot and file on the link below and tell my why.

Thank for all (Sorry if I not good at English).

https://drive.google.com/file/d/1vaJFdK3-ebx2fmr5wMCKmPcmVFjMElUK/view?usp=sharing 

[Icey]

Hi @CongPham ,

Glad to hear that. Please accept your reply above as a solution so that people who may have the same question can get the solution directly.

Best Regards,

Icey

[CongPham]

Are there any know about this issue 😞

[nahid3152]

Hi,
What is your requir required output?

1. Only show Begaining =1 ? or some thing else ?

[CongPham]

Yup,

I only want to show Begining = 1, based on Table type and Chart type and other type

[nahid3152]

Please check this 

https://drive.google.com/file/d/13sazSyCh8ZuZu55kYUwrpoUKL0t1pFV0/view?usp=sharing 

[CongPham · Accepted solution]

Thank you very much!

Finally I found out the way, only need to put more column into Axis and the problem was handled.