0

Series in Bar Chart with different Data sources

Hey Guys from Klipfolio,

I need Help please, urgently !!! :)

I have a Bar Chart with one „Series“ that contained 2 different Data sources.

And that’s the problem, the result isn’t right because the assignment from the X-Axis is made from 2 different Data sources and Hidden Data

 

--------------

This is the calculation with the Series:

(This is the Code from Data source: „Transaktion“)


```
IF(@art; = "1", @umsatz;, BLANK())
```
Minus

 

(This is the Code from Data source: „Transaktion_Details“)


```
IF(
AND(@produkt_id; = "500", @preis; > "0"),
@preis;,
BLANK()
)

+

IF(
AND(@produkt_id; = "500", @preis; < "0"),
@preis;,
BLANK()
)

-

IF(
LOOKUP(
@produkt_id;,
@produkt_id;,
AND(
@kategorie_id; != "7",
@kategorie_id; != "1",
@kategorie_id; != "4",
@kategorie_id; != "5",
@kategorie_id; != "6",
@kategorie_id; != "10",
@kategorie_id; != "11",
@kategorie_id; != "12",
@kategorie_id; != "14",
@kategorie_id; != "32",
@kategorie_id; != "33",
@kategorie_id; != "49",
@kategorie_id; != "42",
@kategorie_id; != "0")
),
@preis;,
BLANK()
)
```

------------

That is my X-Axis,
„@mitarbeiter_nr“ ist from Data_source: „Transaction-details“

(The first code need the same column: „@mitarbeiter_nr“,
but from the Data_source: „Transaktion“,
the Numbers/Names from the Employees are the same.)

``` 
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
@mitarbeiter_nr;,
"1",
"Johannes"
),
"4",
"Uwe"
),
"26",
"Denise"
),
"24",
"Jenny"
),
"28",
"Sonja"
),
"29",
"Vivian"
),
"30",
"Sami"
),
"14",
"Alev"
)
```

 

Data source: „Transaktion_Details“

 

Data source: „Transaktion“ pic 1

Data source: „Transaktion“ pic 2

 

Hidden Data: @created from Data_source: „Transaktion_details“, filtered by Date

 

I hope you can help me???

Greetings, Johannes

3 comments

  • 0
    Avatar
    Meggan King

    Hi Johannes,

    Thanks for all these details. We are going to need to look into this over a support ticket to better understand what is going on in the formulas. You can email support@klipfolio.com

     

    Thanks

    Meggan

  • 0
    Avatar
    Johannes Michalski

    Hey Meggan, i have also a support ticket -

    Request #94078

    but we have not a solution yet :(

    thanks for helping!

    many greetings Johannes

  • 0
    Avatar
    Meggan King

    For reference, one solution to combining multiple data sources in a formula is to use the ARRAY function

     ARRAY( datasource1, datasource2)

     

    https://support.klipfolio.com/hc/en-us/articles/360011416893-Klipfolio-functions#ARRAY

     

     

     

Please sign in to leave a comment.