I want to create a Card/visualization in DOMO which will fetch data from Excel

I want to create a Card/visualization in DOMO which will fetch data from Excel for a PPT and show the info in the below format. How can this be done?
Best Answer
-
This is something I have done both with a DDX brick and a standard text card. The text card is probably easier.
Here is the beastmode:CONCAT(`Title`,'<br>','•',`Value1`,'<br>','•',`Value2`)
There are a variety of bullet symbols, some can be found here:
Additionally I would play around with the chart properties:
That should get you something looking pretty nice.
If I solved your problem, please "accept" my answer as the solution
0
Answers
-
You can use the new Office add-in to have your Excel file be a dataset in Domo. You would then power your card off of that dataset in Domo.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
that I am already using. but I want to create a card or a visualization in the below format from the dataset which is fed from the excel. Data with bullet points
0 -
There isn't a native chart type that would provide that layout. You might want to look at the Domo Bricks to see if there is something that would do that. If you are familiar with Javascript, you could use the Domo Blank Brick and build the bullet list array to pull this off.
You could also look at the notebook card, but I don't think that will meet your needs, but thought I would mention it.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
I tried the domo notebook, but I was not able to add the data from the dataset in it. is there a way this can be done? and does the DOMO PPT plugin fetches notebook in the PPT?
where can I find the DOMO blank Brick?0 -
This is something I have done both with a DDX brick and a standard text card. The text card is probably easier.
Here is the beastmode:CONCAT(`Title`,'<br>','•',`Value1`,'<br>','•',`Value2`)
There are a variety of bullet symbols, some can be found here:
Additionally I would play around with the chart properties:
That should get you something looking pretty nice.
If I solved your problem, please "accept" my answer as the solution
0 -
But in the text card, the issue was that, only the 1st row of the dataset is being fetched. not all rows.
0 -
How is your data formatted? If it is not formatted properly it could easily be reformatted to meet your needs.
If I solved your problem, please "accept" my answer as the solution
0 -
thanks, through this I could achieve a part. but not the entire stuff. I used test dataset
and this is what your solution achieved
How would I be able to fetch row 2?
0 -
Okay, if your data is structured that way you can use the pivot tiles in Magic ETL to put your values that are currently rows as columns and then use the beastmode provided above.
I also got it to work this way:
CONCAT(MAX(CASE WHEN
name1
= 'dheeraj' THENname2
END),'<br>','•',MAX(CASE WHENname1
= 'sandhanshi' THENname2
END))If I solved your problem, please "accept" my answer as the solution
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive