Forum Discussion
Measure with two different columns
Yes, that's kind of sample data. However, you can simplify that and not the screenshot. It's very hard for us to create the solution based on the screenshot. You can just paste some data in the reply. At last, pls let us know what the result you want to get based on the data you provided.
i just created some simple data and provide a solution. pls see the attachment and check if this is what you want.
Hi Ryan
There are no blank values for FQN.
I believe the reason is that I have tried to make a relationship between the two tables, and the DateTime are often not the same, i.e.:
- 24 August 2021 10:04 for one table and
- 24 August 2021 10:01 for the other one
Can I ask (so I understand the process) why you want to create a relationship between the names (FQN)? Is that how you would normally do something like this?
sry ,my mistake. If the time is not important for you . try to move the time and only keep the date and create relationship again.
Yes, that's kind of sample data. However, you can simplify that and not the screenshot. It's very hard for us to create the solution based on the screenshot. You can just paste some data in the reply. At last, pls let us know what the result you want to get based on the data you provided.
i just created some simple data and provide a solution. pls see the attachment and check if this is what you want.
The time is actually quite important since the data will be visualized during the day for operators. However, the data will also be presented weekly - so I guess I can make a copy of the date table and remove the time and only keep dates, then use that date column instead of DateTime column?
Hi Ryan
I have taken some time to look into this calendar table. I have implemented one now - but I'm still not sure how to divide the two figures with each other. I don't have a direct relationship between the two tables, but they are both connected to the calendar table.
you are welcome