Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JSON Export - Confused about List data

Hi, 

I'm testing the export to JSON option to create a Power BI dashboard. I have created a new test board in Trello so I can understand what has been created in the board.

I have created 3 Lists (columns), named

  • Leads/Ideas
  • Live Projects,
  • Lost/Closed/Gone Cold

I have created a new card and placed it into the Live Projects column. However, when I do the JSON export, it implies the card is also associated with the other 2 columns. I'm confused why this would be and it prevents me from being able to use filters correctly in Power BI.

Why isn't the card only related to the column/list it is currently in? (particularly if the card has never been in any other column before?)

image.png

image.png

 

Thoughts and help appreciated!

S

 

1 answer

0 votes
Antonio Panea Community Leader May 17, 2021

Hi @slynch ,

 

Nice to meet you!It could work for you exporting in anny other format? With Trello Business Class I think you have the chance.

I do not know what kind of information you need to get in Power BI. Trello in Business Class has also Dashboards which could give you some infomation with graphics about your board.

Moreover if you are focused in something more related with business and Deal Values you can try Crmble Power-Up (It is free) which also have interesting Dashboard from a business /productivity perspective. Also it is possible to export all your data in Spreadsheet and CSV format.

Hi Antonio,

Thanks for the reply. I cant export in any other format as I am on the free tier. I was hoping someone with more intimate knowledge of how Trello works, could explain why a card would have multiple values of belonging to more than one list, despite the card only ever being in one list (Live Projects). 

Hope I'm explaining this correctly!

Thanks, 

S

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

📹 Favorite Trello templates

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...

2,027 views 17 45
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you