Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have such data:
Period,
Company_name,
Status (1,2,3)
I would like to show on the combo bar: (on separate charts it is simple)
1. Count Company over the period and status - STACKED
* dimmensions: Period, Status,
* experssion: Count(Company_name)
2. On the right axe the share of status 1 over the period as SYMBOL
* dimmension: Preiod
* expression: Count({$<Status = {'1'}>} Compay name) / Count(Company_name)