Forum Discussion

martaredondo's avatar
martaredondo
Icon for Helper II rankHelper II
6 years ago
Solved

Measure in matrix not ok

Hey all,   I want to present 2 measures in a matrix per month (one of the measures is a count and another a sum). I have a date table connected with my table and when I put the measures and month n...
Need Help
  • martaredondo's avatar
    martaredondo
    6 years ago

    Hey guys,

     

    Thanks for your help. I already figure out what happened, I had my date table with date in the format "dd-mm-yyyy 00:00:00" but in my equipment table I had real time (example 06:08:55) so the relationship was only getting the 00:00:00 dates!

     

    Hope you have a nice week,

    Marta

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Marta,

It seems to me that something is going wrong in the relationships.

Make sure the date table has an active relationship and that the date fields in both tables are returning the same values.

 

Kind regards
Joren Venema

Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.