Left Outer - Merge works, but after apply data does not show

[garretzhang]

Hello All,

Questions.... I have two tables. Table 1 - Date only. Table 2 - Date with counts on certain days.

I did a merge queries in "transform data", and then select Left Outer (I selected date from both tables). After I expand the table, I can see everything is working as expected. counts are showing up are the correct date.

example: 

Date            Count

1/1/2021         

1/2/2021         4

1/3/2021         

However, after I close & apply back to the desktop app, the count are missing. The date that the count is supposed to be in are skipped.

example:

Date             Count

1/1/2021

1/3/2021

I refresh the data few tables, closed the app and reopen it, none of them are working.... Does anyone have a solution to this?

Thanks in advance!

Garret

[v-xulin-mstf]

Hi @garretzhang,

Could you provide the screenshot of your issue?

Please enable you apply the change before closing it.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[sevenhills]

If the issue you are talking is on the page - visualization, then Is it something to do with "Show items with no data"?