This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

I want a single chart where viewers can click a selectable metric and see the entire chart updated

Posted 2 weeks ago
Abdul_117
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hello for the past month i have been trying to learn how to do dashboard, my knowledge has become better, but one thing im trying to do and enhance my report.

So, i have metrics around 7 of them and i have been trying to use a chart and using the Y axis as date and X axis as company (brand)
and using the metrics as lets say brand communication as the first metric.

i would like instead of putting 7 charts i would like to make it easier for the viewer to i put the metrics as selectable option and they can press the option they desire so they can see the change instead of bloating the dashboard. 
The issue im facing is when put a dimension control or any type of control the chart will make the X axis as the first metric (brand communication) and would show metrics that are confusing and wrong for the purpose of the dashboard. 
TLDR:Is it possible to create a single chart where clicking a metric changes the data entirely (different metrics), while keeping the X and Y axes the same?
I hope i made some sense.

6 3 183
Topic Labels
3 REPLIES 3

Posted on --/--/---- --:-- AM
DamianS
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM

Hello @Abdul_117  ,Welcome on Google Cloud Community.

Dashboards are combined from widgets, were widgets are combined from one or more metrics. You can create single widget and add this widget to "Dropdown group". Then you will be able to choose which widget should be displayed. 

DamianS_0-1715862223129.png

DamianS_1-1715862250193.png

--
cheers,
DamianS
LinkedIn medium.com Cloudskillsboost

Posted on --/--/---- --:-- AM
Abdul_117
Bronze 1
Bronze 1
In response to DamianS
Reply posted on --/--/---- --:-- AM

Hello @DamianS thank you very much for taking the time to help me.

can you please explain it further, (for dummies)

Thank you again

Regards

Posted on --/--/---- --:-- AM
DamianS
Gold 1
Gold 1
In response to Abdul_117
Reply posted on --/--/---- --:-- AM

@Abdul_117 

1. Log in to your project.
2. Search for Dashboard. Click Create Dashboard

DamianS_0-1715922493252.png

3. Click "CREATE DASHBOARD"

DamianS_1-1715922522932.png

4. Name your dashboard as you want. After naming, click ADD WIDGET

DamianS_2-1715922568427.png

5. From right-side menu choose Dropdown group

DamianS_3-1715922603587.png

6. This will create dropdown container for your widgets.
7. Once again create widget. Choose Metric as widget type

DamianS_4-1715922662672.png

8. Select and configure your metric. 

DamianS_5-1715922697578.png
9. Once done, click APPLY 

DamianS_6-1715922730149.png

10. Drag and drop your newly created widget in my case VM INSTANCE CPU and drop to Dropdown Widget area.

DamianS_7-1715922808350.png

11. Your newly widget with CPU metric has been created and placed on Dropdown widget

DamianS_8-1715922860267.png

12. You can also include your metric widgets by clicking on Widget -> Edit group -> Add widget -> Select widget and pick widget that you want to place under Dropdown menu

DamianS_9-1715922931916.png

DamianS_10-1715922945412.png

DamianS_11-1715922956975.png

DamianS_12-1715922994390.png

In this way you can create your widgets with metrics and combine layout as dropdown menu.
--
cheers,
DamianS
LinkedIn medium.com Cloudskillsboost