Forum Discussion
How to join reports
I have this report:
And I want to join on this report, as you see, the red line on this below is constant, is adding the value:
The "red line" data is this:
And the bars report is:
Maybe the column Mês (Month) and Nome do mês (Name of the month) is causing the trouble, but I've tried several combinations and no success.
Hi,
If your "date" is linked to a "date table" you should be able to show both sets of data on the same visual.
You can create a date table using Calendar() function.
This is done using the bar line visual available out of the box.
Using this visual will give you 3* axis.
- Date
- Values for first data set
- Values for second data set
Hope this helps,
Jay
5 Replies
is there a relationship between two ytables on any primary key?
I forgot
I build this, but is not working, I hope you understand portuguese ehhehe...
Maybe the problem is the column name? Or data inside?
Should be the same column name, and the same data?
For example Column = Month nd data: january, february...
Hi,
If your "date" is linked to a "date table" you should be able to show both sets of data on the same visual.
You can create a date table using Calendar() function.
This is done using the bar line visual available out of the box.
Using this visual will give you 3* axis.
- Date
- Values for first data set
- Values for second data set
Hope this helps,
Jay
