Data doesn't show in a correct period
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
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.
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.
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.
Hello, @rniederkirchner ,
Show your screen or code, give more details .