Data doesn't show in a correct period

rniederkirchner
rniederkirchner Member, Infor Partner Posts: 3

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

Best Answer

  • rniederkirchner
    rniederkirchner Member, Infor Partner Posts: 3
    Answer ✓

    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.

Answers

  • Fabiano Silva
    Fabiano Silva Member, Infor Partner Posts: 50

    Hello, @rniederkirchner ,

    Show your screen or code, give more details .

  • pijpema
    pijpema Unconfirmed, Member, Infor Partner Posts: 12

    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.