Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have small confusion in data.
I have two tables and in botht the tables I have some fields as same and some other different fields.
my req is: 1. one dashboard I need to show count of both values based on some field,
2. I want to show separate table count values.
how to show?
3 bas charts | |||
example: | 1.count of company both=18 | in one report | |
2.count of mi =9 | separate MI report | ||
3.count of md=9 | separate MD report | ||
Hi,
Try like this,
MI:
Load *,'MI' as Flag from MI_Table;
Concatenate
MD:
Load *,'MD' as Flag from MD_Table;
chart1:- count({<Flag=>}Company)
chart2:- count({<Flag={"MI"}>}Company)
chart3:- count({<Flag={"MD"}>}Company)
Regards,
Hi,
Try like this,
MI:
Load *,'MI' as Flag from MI_Table;
Concatenate
MD:
Load *,'MD' as Flag from MD_Table;
chart1:- count({<Flag=>}Company)
chart2:- count({<Flag={"MI"}>}Company)
chart3:- count({<Flag={"MD"}>}Company)
Regards,
Hi,
You can do a simple concatenate like below.
Load *,'A' as Source from Table A;
Concatenate
Load *,'B' as Source from Table B;
For 1 Chart just count the Company.
For 2 Chart use set analysis to filter to source A
For 3 Chart use set analysis to filter to source B
Regards,
Kaushik Solanki
Try loading the tables like:
T1:
Load
*,
1 as flag
From <>;
Concatenate
Load
*,
2 as flag
From <>;
Now in the front-end,
Dim=Company
For All company report : =Count(Model)
For First table company report : =Count({<flag={1}>}Model)
For Second table company report : =Count({<flag={2}>}Model)
thanks all ,I will check and update you
if I have the column names are different but inside values are same how can I get join and use?
example: 1st table column name :company
2nd table columnname :business I need to combine count I want to show how to map this?