Forum Discussion

geeklarokcmie's avatar
geeklarokcmie
Helper III
2 years ago
Solved

Line Graphs and Card Visuals

Based on the below mock data:

I'm looking to produce the below visuals:

1st Visual - Year and Quarter Selection should change the visuals accordingly

2nd Visual - AI Onboard Cost - Forecast and Actuals should be shown as line graphs 

3rd Visual - AI User Support - Forecast and Actuals should be shown as cards with 

4th Visual - If the forecast exceeds actuals, then a text showing AI Process on target

                   If the forecast is below actuals, then the a text showing AI Process behind target

 

QuarterYearAI Onboard Cost ForecastAI Onboard Cost ActualsAI User Support ForecastAI User Support Actuals
1Q20232200002000001894419000
2Q20232100002300001824618995
3Q20232500003000001860118881
4Q20233500003750001866218779
1Q20243000004000001859518719
Need Help

6 Replies

  • Arul's avatar
    Arul
    Super User
    2 years ago

    geeklarokcmie ,

    Could please explain it in more detail if possible? Provided information is inadequate to make the visuals. Please mention which visual you want for all of them. And also the expected functionality of visual 1.

    • geeklarokcmie's avatar
      geeklarokcmie
      Helper III
      2 years ago

      I'd like to represent the below in form of visuals:

      • AI User Support forecast & actual in a Card Visual 
      • AI Onboard Cost forecast & actua in a Line Graph Visual
      • AI Process on Target and Behind Target can be text visual with calculation behind the scene
      • Year/Quarter can be a slicer selection. Based on the selection of year/quarter the data in visuals change accordingly.

      I hope that helps.