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.
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.
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?
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
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