Data doesn't show in a correct period

rniederkirchner · 2024-11-13T10:04:36+00:00

There was an error rendering this rich post.

Hello,

I have created a dashboard for the event and I have two tables as scripted sources. I used the date hierarchy to unify the data. But for some reason when I try to visualize my data from one table it appears in the correct period but the other is summarized for today.

Do you have any idea what should I change in order to achieve the expected behavior?

Kind regards,
Roland

Find more posts tagged with

Accepted answers

rniederkirchner

Hello All,

Thanks for the answers! The issue was with the Birst-built hierarchy and it couldn't join the data correctly.

Take away: Always create a custom hierarchy where you can define the keys for your data set.

All comments

Fabiano Silva

Hello, @rniederkirchner ,

Show your screen or code, give more details .

pijpema

Indeed, without the code of your query difficult to interpret, though a join with 2 UTC-date-fields is usually not accurate. So, I assume you have created a 1:n relation in your join. Depending your assignment of the result-set: a accumulation is likely. And depending the presentation format, this may very as well.

Suggest you run this code separately somewhere to understand the correctness of your query.

rniederkirchner

Hello All,

Thanks for the answers! The issue was with the Birst-built hierarchy and it couldn't join the data correctly.

Take away: Always create a custom hierarchy where you can define the keys for your data set.