Skip to main content
Sujets#Line Chart

#Line Chart0 personne en discute

Posez une question…
Gagab Mishra (Future Thinker)
2 déc. 2022, 15:10
How can we combine these two graphs (Bar and Line) together? Line graph has four different measure and Bar graph has two different measure.

Hello,

there are 3 different dates and with these datasets 2 different graphs has been created.

Bar graph:

How can we combine these two graphs (Bar and Line) together? Line graph has four different measure and Bar graph has two different measure.Line Graph:

image 

The requirement is to merge these graphs and have only one final graph with all these values.

The output should look like this:

image 

I have tried combining but I always leave out one or two measure.

I am also attaching the tableau workbook for the reference.

 

If there is any idea or workaround, please let me know as it would of great help!

 

Thank you!

 

⌗[Using Tableau]​ ⌗[Tableau Desktop]​ #Tableau Server​ ⌗[Tableau Products]​ ⌗[Query / Data Flow]​ ⌗Community​ #Bar Chart​ #Line Chart​ 

Merge-Test-1.twbx
5 réponses
  1. Michael Hesser (Oak Street Health)
    6 déc. 2022, 01:36

    Sorry @Param Sahu​ ​ -- it may be my new computer but I am unable to unzip your TWBX to get to the data sources. Can you send all three independently?

    Michael Hesser (Tableau Forum Ambassador)

    If this response has answered your question, kindly click "Best Answer"

Rédiger une réponse...
0/9000
Umer Farooq (Developer chez 10Pearls) a publié du contenu dans * CRM Analytics (fka Tableau CRM) *
11 janv. 2021, 19:39

I have a simple line chart with 3 measure values and one dimension , Is it possible via any option or customisation to let's say if any user wants to visualize only one line representing one measure rather than all 3 ( as by default we have 3 lines) as we have this feature in other BI tools like looker and tableau

Thanks in Advance

1 commentaire
  1. Marta Maldonado (Omega CRM Consulting)
    11 janv. 2021, 22:16

    I didn't tested but maybe with a toggle with the measures and data binding them to the query measures of the chart.

    Static query for the toggle widget:

    "static_1": {

    "type": "staticflex",

    "numbers": [],

    "strings": [],

    "groups": [],

    "columns": {

    "Display": {

    "type": "string"

    },

    "Measure2": {

    "type": "aggregate",

    "dataset": {

    "name": "opportunity"

    },

    "aggregateFunction": "Measure2__func",

    "field": "Measure2__field"

    }

    },

    "broadcastFacet": true,

    "selectMode": "singlerequired",

    "values": [

    {

    "Display": "count of *",

    "Measure2__field": "*",

    "Measure2__func": "count"

    },

    {

    "Display": "sum of Amount",

    "Measure2__field": "Amount",

    "Measure2__func": "sum"

    }

    ],

    "label": ""

    },

    And bindings similar to these:

    measure1 (count rows) ---> row(static_1.selection, [0], ["Measure2__field", "Measure2__func"]).asObject() --> ["*","count"]

    measure2 (sum of amount) --> row(static_1.result, [1], ["Measure2__func", "Measure2__field"]).asString() --> ["sum","Amount"]

    imagen_2021-01-11_231625.png
Rédiger un commentaire...
0/9000
Gwen Mui (Lightspeed Systems) a publié du contenu dans * Sales Cloud - Best Practices *
11 déc. 2020, 01:15

Hi, I created a report with a parentgroupval field to show how much revenue was generated from marketing and want to plot this % on a line chart on secondary axis (primary axis is the revenue $). I was able to build this on the dashboard but the Line chart didn't display. Have anyone encountered this issue? 

Screenshot 2020-12-10 171616.png
1 commentaire
Rédiger un commentaire...
0/9000
Bhavin Patel (Community Experience Manager chez Salesforce) a publié du contenu dans * CRM Analytics (fka Tableau CRM) *
27 juil. 2020, 13:16

📚 Learn to create a combo chart 📊 to display at least two related series of data, such as discrete grouped values as vertical bars overlaid with a line chart representing an average value.

 

Here's how ⬇

Combo Charts

1 commentaire
Rédiger un commentaire...
0/9000